SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO TH

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?

Question Posted / prasad

1 Answers
6608 Views
TCS, I also Faced
E-Mail Answers

SEQUENTIAL FILE I HAVE ONE RECORD,I WANT 100 RECORDS IN TARGET?HOW CAN WE DO THAT?PLS EXPLAIN ME AN..

Answer / 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

More Data Stage Interview Questions

Enlist various types of routines in datastage.

0 Answers

How do you design PX Routines ?

1 Answers

I have a few records just I want to store each records tow times in target how?

2 Answers Polaris,

What are the partition techniques available in your last project?

1 Answers

which is more expensive hash or modulus partitioning? when do you use modulus partitioning?

2 Answers TIAA CREF,

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 Answers

what is use of SDR function?

0 Answers CGI,

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers Wipro,

30 jobs are running in unix.i want to find out my job.how to do this?Give me command?

3 Answers

What is the different type of jobs in datastage?

0 Answers

iam new to datastage...now i want to know what are fact tables, dimension tables in bank domain...if any body knows plz tell me asap..

4 Answers Wipro,

How to implement complex jobs in data stage?

0 Answers

For more Data Stage Interview Questions Click Here