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 / vijaya
Hi
first sort the input date then use the transformer stage by
using stage variables you can use the logic like check the
first record then check the second record if both are equal
send the output to o/p1 or else send to o/p2....
I hope i made u understand the logic
Is This Answer Correct ? | 2 Yes | 11 No |
Post New Answer View All Answers
How one source columns or rows to be loaded in to two different tables?
Define repository tables in datastage?
How to perform incremental load in datastage?
What is the difference between orabulk and bcp stages?
Why do we use link partitioner and link collector in datastage?
Why do you need stage variables?
What is the difference between odbc and drs stage?
Highlight the main features of datastage?
Which commands are used to import and export the datastage jobs?
how do u catch bad rows from OCI stage? And what CLI stands for?
Can you define merge?
What is meta stage?
how to export or import the jobs in .ISX file
What can we do with datastage director?
What is a datastage job?