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

What are the steps needed to create a simple basic datastage job?

667


Can you explain link buffering?

732


How do you reject records in a transformer?

637


Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

1757


which r the connectors used in san?

1802






Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

977


To see hidden files in LINIX?

950


WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

3275


What are stage variables, derivations and constants?

680


What are the different types of lookups in datastage?

637


How to implement complex jobs in data stage?

621


What is orabulk stage?

644


Triggers,VIEW,Procedures

807


1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

2327


What are the different kinds of views available in a datastage director?

609