i/p o/p1 o/p2
1 1 4
1 1 5
1 1 6
2 2
2 2
2 2
3
3
4
5
6
how to populates i/p rows into o/p1&o/p2 using datastage
stages?and also the same scenario using sql?
Answer Posted / kavitha
sequentialfile-----copy-----head and tail(in that we have options like no of rows=6 for head and n..o..r=4 for tail)then connect two data sets to that head and tail u will get
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is orabulk stage?
What are the different kinds of views available in a datastage director?
What are the steps required to kill the job in Datastage?
What are some different alternative commands associated with "dsjob"?
which r the connectors used in san?
How do you remove duplicate values in datastage?
Differentiate between datastage and datastage tx?
Can you explain players in datastage?
How do you run datastage job from the command line?
What are iconv and oconv?
How complex jobs are implemented in datstage to improve performance?
How do you generate sequence number in datastage?
Can you explain tagbatch restructure operator?
What are the types of hashed files in data stage
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...