Interested to Buy Any Domain ? << Click Here >> for more details...
I have 2 Files like
fileA fileB Output1 Output2 Output3
1 6 1 6 11
2 7 2 7 12
3 8 3 8 13
4 9 4 9 14
5 10 5 10 15
6 11
7 12
8 13
9 14
10 15
please let know
- 6 Answers
- 9458 Views
- I also Faced
- E-Mail Answers
Answer Posted / mohit
We can solve this by using Change capture stage. First,we
use source as 'A' and refrerence as 'B' both of them are
connected to Change capture stage. From, change capture
stage it connected to filter stage and then targets X,Y and
Z.
(Change Code '0'--->exist in both, copy record
Change Code '1'--->Exists in SRC 'A', INSERT record
Change Code '2'--->Exists in SRC 'B', DELETE record
Change Code '3'--->Exists in 'A' & 'B' with changes, UPDATE
record)
In the filter stage:
Change_code column=1 it goes to 'X' [1,2,3,4,5]
Change_code column=0 it goes to 'Y' [6,7,8,9,10]
Change_code column=2 it goes to 'Z' [11,12,13,14,15]
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Where do you see different stages in the designer?
How do you schedule or monitoring the job?
Why we use surrogate key?
Why fact table is in normal form?
1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)
Explain connectivity between datastage with datasources?
Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
Enlist various types of routines in datastage.
options available in sequence job to run,validate?
What are the enhancements made in datastage 7.5 compare with 7.0?
Define Routines and their types?
what is flow of project?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Difference between server jobs & parallel jobs?
