Interested to Buy Any Domain ? << Click Here >> for more details...
INPUT file 'A' contains:
1
2
3
4
5
6
7
8
9
10
input file 'B' contains:
6
7
8
9
10
11
12
13
14
15
Output file 'X' contains:
1
2
3
4
5
Output file 'Y' contains:
6
7
8
9
10
Output file 'Z' contains:
11
12
13
14
15
How can we implement this in a single ds job?
- 11 Answers
- 18276 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / sarita
Hi Shar,
You aret hardcoding the values in your approach.I think the other approach could be:
1)Take a left outer join on the tables A and B. Common column for join can be a dummy=1.
2)Now output would be 2 columns one will have values 1,2,3,4,5,6,7,8,9,10 other will have NULL....NULL...6,7,...10
in expression transf...take a variable... chk when col a- col b != 0,then put flag X else Y
3)Then similarly do a join for B & C table and use same logic
Hope it works!
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
sed,awk,head
What is datastage engine?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What is a datastage job?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
How to manage date conversion in Datastage?
Can we use target hash file as a lookup ?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
How to convert RGB Value to Hexadecimal values in datastage?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the functionalities of link partitioner?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
What are stage variables?
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?
What are the various kinds of the hash file?
