Sequential file i have one record,i want 100 records in target?How can we do that?Pls explain me and what stages are there?What logic?
Answer / teju
take source sequential file with 1 rec and take target file with 100 records in between use a copy stage to map the source 1 rec to target 100 records.
| Is This Answer Correct ? | 0 Yes | 0 No |
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
when U have a remove dublicate option in sort stage, why we have a remove dublicate stage in PX, thought it is recamended to sort data before using a remove dublicate stage. I hae been thinking this from days....
What is the precedence of stage variables,derivations, and constraints?
Nls stands for what in datastage?
i want anser this question empno,ename,sal 12,mmm_ww,200 13,nnn_xx,300 14,bbb_qq,400 which stages are take which types of logicks are doing pls help me i don't need "_"ex nnnxx this type i want
What is the difference between Datastage 7.5 and 7.0?
What is difference between 8.1 , 8.5 and 9.1 ?
I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?
How do y read Sequential file from job control?
What are transforms and what is the differenece between routines and transforms?
Differentiate between hash file and sequential file?
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.