Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 8902 Views
- I also Faced
- E-Mail Answers
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 are routines in datastage?
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.
what is the diff b/w switch and filter stage in datastage
Hai..,in datastage how to explain project in interview?please explain any domain please.
Difference between sequential file and data set?
What is the precedence of stage variables,derivations, and constraints?
file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks
What are the primary usages of datastage tool?
If the job aborted in a sequencer, how can we start that from the previews successful job.
Where do you see different stages in the designer?
source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.
Can we use Round Robin for aggregator?is there any benefit underlying?
Teradata 
