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
- 6670 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 |
if we take 2 tables(like emp and dept), we use join stage and how to improve the performance?
What is the project in datastage?
I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?
in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?
What is lookup table?
Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 Answers Cognizant, HCL, TIAA CREF,
How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?
Explain ibm infosphere information server and highlight its main features?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
how to capture rejected data by using join stage not for lookup stage. please let me know
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
What could be a data source system?
Teradata 
