Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6526 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / subhash
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 |
Post New Answer View All Answers
Explain Quality stage?
what is flow of project?
how do u catch bad rows from OCI stage? And what CLI stands for?
How will you move hashed file from one location to another location?
Could anyone give brief explanation bout datastage admin
How to read multiple files using a single datastage job if files have the same metadata?
Define APT_CONFIG in Datastage?
What is aggtorec restructure operator?
Have you have ever worked in unix environment and why it is useful in datastage?
What are the difference types of stages?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
On which Dimension Table you implemented SCD Type in your Project
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
What are the primary usages of datastage tool?
Why we use surrogate key?
