Interested to Buy Any Domain ? << Click Here >> for more details...
I am having the 2 source files A and B and I want to get the
output as, the data which is in file A and which doesn't in
file B to a target 1 and which is in file B and which doesn't
in file A to a target 2?
- 3 Answers
- 7438 Views
- I also Faced
- E-Mail Answers
Answer Posted / reddymkl.dwh
FullOuter
FileA------->Join--------->Filter-------->T1
| |
| |
| |
| |
FileB T2
Use Fullouter Join Then
Filter-------> Where =Right.link=''
Where =Left.link=''
Nothing but A-B, B-A scenario.
Plz correct me if am wrong.....
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can you implement SCD2 using join, transformer and funnel stage?
What are the different type of jobs in datastage?
What is a ds designer?
Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?
Define Job control?
sed,awk,head
how to add a new records into source?
What is difference between symmetric multiprocessing and massive parallel processing?
What are data elements?
Explain how a source file is populated?
What is the difference between an operational datastage and a data warehouse?
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)
Can you explain how could anyone drop the index before loading the data in target in datastage?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
How you Implemented SCD Type 1 & Type 2 in your project?
