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?
1)
JOB1: SRC---->COPY---->TGT
SEQuence:
START LOOP---->JOB1----->END LOOP Activity.
In TGT stage use 'Append' Mode.
By Looping 100 time, we can get 100 records in target.
2)
SRC---->Transformer---->TGT
By using Looping Variable in the Transformer, we can achieve
this.
Loop While Condition "@ITERATION <=100"
Is This Answer Correct ? | 9 Yes | 0 No |
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
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?
what is the use of invokation id
What is the difference between datastage and datastage tx?
Describe stream connector?
how will u design file watch jobs?
What are the unit test cases you used in your project?
what is ds administrator used for?
what is parameterset?
can a fact table contains textual information
6 Answers HCL, HCL BSERV, IBM,
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 ?