Input file one has data as shown below
1
2
3
4
5
6
7
8
Input file two has data like
6
7
8
9
10
11
Design a data stage job which will provide me three output files as shown below:
Output 1
6
7
8
Output 2
1
2
3
4
5
Output 3
9
10
11
Let me know your answers
Answer Posted / pavani
by using join type=full outer.we have to get output has 2 columns. 1st_column values are first inputs and remaining nulls,2_column values are second input and remaining are nulls.
then by using transformer write a constraint
1.output----->1st_column=2_column;
2.output----->2_column=null or'';(depending on input data)
3.output----->1st_column=null or'';(depending on data)
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Define Job control?
In Datastage, how you can fix the truncated data error?
Define APT_CONFIG in Datastage?
explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How to perform incremental load in datastage?
Describe the main features of datastage?
What is the command line function to import and export the ds jobs?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
What are the types of containers in datastage?
What are data elements?
what is the use of skid in reporting?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?