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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Difference between server jobs & parallel jobs?

648


What is staging variable?

622


What is a quality stage in datastage tool?

625


How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1076


Explain the importance of surrogate key in data warehousing?

706






What is the difference between datastage and datastage tx?

590


Different ways a project can be moved to production ?...example ….export-import and Version control.

1931


Terminate Activity

837


in oracle target stage when we use load option and when we use upsert option?

1748


How do u convert the columns to rows in datastage?

692


What are the enhancements made in datastage 7.5 compare with 7.0?

707


Triggers,VIEW,Procedures

800


hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1463


Does datastage support slowly changing dimensions ?

659


What are the job parameters?

703