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 Answers
- 6226 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Explain the datastage parallel extender (px) or enterprise edition (ee)?
i have a small question for datastage, After the desinging (i.e., transformations and loading)part, what we can do?
How to remove duplicates in transformer stage? in parallel mode
what about data stage requirement
How to read multiple files using a single datastage job if files have the same metadata?
file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4
Differentiate between datastage and informatica?
i hav source like this . deptno,sal 1,2000 2,3000 3,4000 1,2300 4,5000 5,1100 i want target like this target1 1,2000 3,4000 4,5000 target2 2,3000 1,2300 5,1100 with out using transformer
what is the difference between the active datawarehouse and datawarehouse
How can we run same job in 1 day 2 times
How to read the length of word in unix?
How to create environments and call them? What is the use defined variables?
Teradata 
