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 the method of removing duplicates, without the remove duplicate stage?
Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.
What is the flow of loading data into fact & dimensional tables?
what is a message handler
Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.
Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance
explain unit testing,systemtesting,integrated testing
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
What are routines in datastage?
Thanks to all people who are posting their comments...
Could anyone give brief explanation bout datastage admin
is it possible to access the same job by two users at a time in DataStage?