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
Difference between server jobs & parallel jobs?
What is staging variable?
What is a quality stage in datastage tool?
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...
Explain the importance of surrogate key in data warehousing?
What is the difference between datastage and datastage tx?
Different ways a project can be moved to production ?...example ….export-import and Version control.
Terminate Activity
in oracle target stage when we use load option and when we use upsert option?
How do u convert the columns to rows in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
Triggers,VIEW,Procedures
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
Does datastage support slowly changing dimensions ?
What are the job parameters?