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
- 14956 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
What is the purpose of interprocessor stage in server jobs?
how to run a sequential file stage in parallel if the stage is used on the TARGET side
Name the different types of Lookups in Datastage?
What is the difference between informatica and datastage?
What are sequencers?
Whats difference betweeen operational data stage (ods) and data warehouse?
Can you explain engine tier in information server?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
Differentiate between datastage and datastage tx?
What are transforms and what is the differenece between routines and transforms?
Differentiate between odbc and drs stage?
How many types of hash files are there?
How can we perform the 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
How do you schedule or monitoring the job?
