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
- 6538 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
What is the process of killing a job in datastage?
What are the components of datastage?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How to clean the datastage repository?
Define Data Stage?
How do you remove duplicate values in datastage?
what are the errors,warnings in datastage
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
AGGREGATOR default datatype
How do you run datastage job from the command line?
What is meta stage?
What are the various kinds of containers available in datastage?
Can you explain kafka connector?
Name the command line functions to import and export the DS jobs?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
