5) A file contains 10 (1-10) I want trgt like
Trgt 1 trgt 2 trgt 3
1 2 3
4 5 6
7 8 9
10

Answers were Sorted based on User's Feedback



5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10 ..

Answer / venkatesh

the flow will be like this

source---->transformer----->t1
--------->t2
----------->t3
in transformer create a stage variable which holds the value
of mod(id,3) for instance it will be like this

mod(ds.link2.inputrow id,3) |stgvar
______________________________________________|__________
|

use this stage variable in constraint as

ds.link4 stgvar=1
ds.link5 stgvar=2
ds.link6 stgvar=0

connect the input to the output in transformer


u will get the desired output

Is This Answer Correct ?    3 Yes 0 No

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10 ..

Answer / srikanth

We can use round robin partition method.

Is This Answer Correct ?    4 Yes 2 No

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10 ..

Answer / joe

we can use a transformer with constraint mod(@INROWNUM,3)=2
for trgt1,, =1 for Trgt2, =3 for Trgt3

Is This Answer Correct ?    4 Yes 3 No

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10 ..

Answer / mcssrinivas009

we can use random partion concept

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More Data Stage Interview Questions

what is operator combinality in datastage?

1 Answers   TCS,


Give an idea of system variables.

0 Answers  


IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  


How to perform incremental load in datastage?

0 Answers  


In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

0 Answers  






what is ds administrator used for?

0 Answers  


What is oci?

0 Answers  


How to Convert the columns into rows?

2 Answers  


Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?

2 Answers   TCS,


wt is the diff b/w odbc and oracle stage

2 Answers   Accenture, HCL,


Hai..,in datastage how to explain project in interview?please explain any domain please.

1 Answers   Wipro,


A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

0 Answers  


Categories