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
- 18798 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
What is container and then types?
Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance
Can we use target hash file as a lookup ?
What is job control?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what is initial load and incremental load
How do you load 10 different sources with 10 different layouts to 10 different tables?
Explain connectivity between datastage with datasources?
what is advantages of snowflake when it is used?
Hi Vijay here For Four CPU's how many nodes will required?
How to convert RGB Value to Hexadecimal values in datastage?
Teradata 
