Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 13767 Views
- IBM, I also Faced
- E-Mail Answers
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 are some prerequisites for datastage?
Is it possible to query a hash file?
Whats difference betweeen operational data stage (ods) and data warehouse?
How you Implemented SCD Type 1 & Type 2 in your project?
Explain the situation where you have applied SCD in your project?
On which Dimension Table you implemented SCD Type in your Project
How do you generate sequence number in datastage?
What are the enhancements made in datastage 7.5 compare with 7.0?
What is the purpose of interprocessor stage in server jobs?
What is the different type of jobs in datastage?
How can one find bugs in job sequence?
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.
how to export or import the jobs in .ISX file
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
