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
- 18304 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / vaibhav
Hi Subbuchamala..
I marked this ans as no bcoz CDC stage works row by row i.e. on key column basis.. here for all the 10 records change_code will be 3 so it cannot be differentiated into 3 target files...
Different approach will be.. take union of 2 input tables and use transformer stage and filter on the basis of rownumber..
Let me know if I am wrong..
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
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 data elements?
How do you reject records in a transformer?
If you want to use the same piece of code in different jobs, how will you achieve it?
Why do we use exception activity in Datastage?
Define oconv () and iconv () functions in datastage?
Name the different sorting methods in datastage.
What is staging variable?
how many rows sorted in sort stage by default in server jobs
What are the stages in datastage?
Differentiate between datastage and datastage tx?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
What is the difference between datastage and informatica?
Could anyone give brief explanation bout datastage admin
