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
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 |
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 |
what is operator combinality in datastage?
Give an idea of system variables.
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.
How to perform incremental load in datastage?
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?
what is ds administrator used for?
What is oci?
How to Convert the columns into rows?
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?
wt is the diff b/w odbc and oracle stage
Hai..,in datastage how to explain project in interview?please explain any domain please.
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?