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
What is the difference between informatica and datastage?
How you Implemented SCD Type 1 & Type 2 in your project?
How do you schedule or monitoring the job?
client know skid info?
Differentiate between hash file and sequential file?
Can you define merge?
What are data elements?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
How to clean the datastage repository?
whom do you report?
How a routine is called in datastage job?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What could be a data source system?
How you can fix the truncated data error in datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE