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
- 18624 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
What are the repository tables in datastage?
project Steps,hits, Project level HArd things,Solved methods?
Explain datastage architecture?
What is the difference between datastage and informatica?
CHANGE CAPTURE
Name the third party tools that can be used in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?
What is a merge in datastage?
How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...
What are the processing stages?
what is the use of materialized view?
Define ds designer?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
What is the purpose of interprocessor stage in server jobs?
