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
- 6011 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 |
How many areas for files does datastage have?
In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..
What are the functionalities of link partitioner and link collector?
hi i am bhavani, in real time data stage who is the source provide? and how to recevied in developer? Pls send me answer
Difference between the Sequence and Sequencer in DS?
it is possible to load two tables data into one sequential file?if possible how?plz share with me?
Explain Quality stage?
what is meta data? Explain? Where it is used?
Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C
parallel jobs run on cluster machines. server jobs run on smp and mpp. What do mean by cluster mechines and SMP and MPP..?
Can aggregator and transformer stages use to sort the data? How ?
What are the types of containers in datastage?
Teradata 
