How do you generate sequence number in datastage?
How to read the length of word in unix?
What are the different common services in datastage?
how do u catch bad rows from OCI stage? And what CLI stands for?
I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
i want job aborted after some records are loaded into output by using only sequential stage and dataset
Instead of using shared container in a job, I use jobs which perform similar function as Container in the sequence. Then what is the need of Shared Container?
Define Job control?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
1)Source file contains one record, I want 100 records in target file.
Pls tell me what is troubleshooting in datastage view?
country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?