my source seq file have
col1
1
2
3
4
5
6
7
8
9
i have 4 targets
t1 t2 t3 t4
1 2 3 4
5 6 7 8
9 like this how we can get?

Answer Posted / srikanth

hi
it is possible by using transform stage
select the function in that select the mathematical in that
select the mod function and run the job

you will get the answer

Thanks & regards
srikanth.k
9573056597

Is This Answer Correct ?    3 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

973


how to abort the job its matain duplicates?

2109


Define Job control?

681


Terminate Activity

841


What is the roundrobin collector?

643






How to convert RGB Value to Hexadecimal values in datastage?

3462


whom do you report?

1506


describe the Steps to confiure a Qlogic switch

1944


I have a few records just I want to store data in to targets cycling way how?

1905


What is merge stage?

768


What are stage variables, derivations and constants?

675


What all the types of jobs you developed?

668


How to read multiple files using a single datastage job if files have the same metadata?

744


What are the components of ascential data stage?

655


What is the difference between account and directory options ?

628