Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4 Answers
- 6702 Views
- IBM, PR3 Systems, I also Faced
- E-Mail 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
Which commands are used to import and export the datastage jobs?
What all are the different way to run a job?
Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.
What is the purpose of pivot stage?
What are the differences between datastage and informatica?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
how to write server Routine coding?
What could be a data source system?
What is process model?
Differentiate between hash file and sequential file?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
client know skid info?
Which warehouse using in your datawarehouse
How do you schedule or monitoring the job?
