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
- 6606 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
Define meta stage?
On which interface you will be working as a developer?
Where do you see different stages in the designer?
Explain datastage architecture?
What are the areas of application?
What are the different types of lookups in datastage?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
I have a few records just I want to store data in to targets cycling way how?
How to implement complex jobs in data stage?
How many types of stage?
Explain entity, attribute and relationship in datastage?
What is datastage?
Difference between in process and inter process?
Explain how a source file is populated?
How a routine is called in datastage job?
