Interested to Buy Any Domain ? << Click Here >> for more details...
I have 2 Files like
fileA fileB Output1 Output2 Output3
1 6 1 6 11
2 7 2 7 12
3 8 3 8 13
4 9 4 9 14
5 10 5 10 15
6 11
7 12
8 13
9 14
10 15
please let know
- 6 Answers
- 9875 Views
- I also Faced
- E-Mail Answers
Answer Posted / radhika m
Add an extra column 'colA' and 'colB' to the files 'A' and 'B' respectively. Let the value for colsA be 'a' for all the rows in file 'A' and the value for colB be 'b' in file 'B'(using the column generator stage).Now join both the files using join stage using 'ID' column. Perform full outer join. Map the ID col, colA and colB to output. Next pass it through a transformer.
Transformer constraint:
1) file X - colA=a and colB<>b ----->[1,2,3,4,5]
2) file Y - colA=a and colB=b------->[6,7,8,9,10]
3) file Z - colA<>a and colB=b------>[11,12,13,14,15]
Drop cola and colB in the output.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the areas of application?
What are routines in datastage?
what is the use of materialized view?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
How many areas for files does datastage have?
Where the datastage stored his repository?
Difference between in process and inter process?
How to RD using transformer?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What are data elements?
Different ways a project can be moved to production ?...example ….export-import and Version control.
options available in sequence job to run,validate?
Where do the datastage jobs get stored?
How rejected rows are managed in datastage?
In Datastage, how you can fix the truncated data error?
