DSXchange

hi to add more on tht wht the requirment is FIRST TIME RECORD COME custkey customer_no Nomenclature_Code code custname effdate endate 1 101 10050 2001 ABC 06/27/2005 - SECOND TIME RECORD COME Nomenclature_Code changes custkey customer_no Nomenclature_Code code custname effdate endate 1 101 10050 200...

hi there I have this DIM_Customer table aginst the columns the requirment is written tht this column is type 1 and this column is type 2 dimension like County_City_Code 1(type1) Nomenclature_Code 2(type2) and so on 1) they want effdate and enddate aginst all type 2 dimensions 2) is tht possible to h...

this command give me whole body of excel file i want attachment
$mail bobby@express.com</datastage01/nin/Act_Sub.csv

hi
i did this ,its not working i went to EXECSH and in input i wrote

$mail bobby@express.com</datastage01/nin/Act_Sub.csv
thanks
bobby

sri
u said DSsend in valueexpression should i give path of tht file
thanks
bobby

Hi,
I want to send that file so u mean routine activity i should use , can u advise wht routine name as i have not seen any mail in there
thanks
bobby

hi,
i have an execl file which i load then i send to client for test data , can i automate that as soon as the job complete it automtically get emailed to them , i mean any automatic process i can do.
thanks
bobby

Hi ,
I have input
1 n0
1 n1
1 n2
2 b1
2 b2
2 b3


output

1 no, n1,n2
2 b1,b2,b3

how can i achieve that.
Thanks,
Bobby

MY SOURCE IS RECORD_ID IRD_NO FROM_LOC TO_LOC 2946632 R0022241458 8455100600889092 900270001 3165011 R0022241458 900270001 8455100622188010 3168849 R0022241458 911060001 8455100622188010 Target should look like RECORD_ID IRD_NO FROM_LOC TO_LOC 2946632 R0022241458 8455100600889092 900270001 3165011 R...

Hi,
please advice i have date in varchar want to change in Timestamp
12-oct-2004(varchar) to 2004-10-12 00:00:00 (Timestamp)
Thanks,
Bobby

Hi To add more RECORD_ID IRD_NO D FROM_LOC TO_LOC 2946632 R0022241458 S 8455100600889092 900270001 3165011 R0022241458 S 900270001 8455100622188010 3168849 R0022241458 S 911060001 8455100622188010 i want to create a fictious record between 3165011 and 3168849 so as to plug the differnce. Thanks Bobby

Hi, we have requirment in which if( m2.to_loc<>m.from_loc ) ,we have to create fictious record and insert it in Target Table like in (ex1) so i have run the Select in TOAD and its fine so i am palnning to copy same in Datastage ,But need advice on insert Thanks, Bobby ex1) insert into eqt_movement_a...

Hi, Someone has designed this in PL/sql ,Its inserting the Fictious Record upon a condition, Its selcting from Same Table , Inserting in same Table and updating same table, Plz advice the approach in Datastage. Thanks Bobby ********************************/ v_dt_diff number(2):=0; v_ird varchar2(11)...

Hi ,
please advice if it possible to run just a single job every hour in datastage,
if yes whts the option.
Thanks,
Bobby

hi, Some one has written this code in Job Control in Datastage Can u please advice wht can be best procedure to follow this. Thanks, Bobby * Setup SAPimportParentDIST, run it, wait for it to finish, and test for success hJob2 = DSAttachJob("SAPimportParentDIST", DSJ.ERRWARN) If NOT(hJob2) ...