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
- 7594 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
how do u catch bad rows from OCI stage? And what CLI stands for?
Where do the datastage jobs get stored?
Which algorithm you used for your hashfile?
Can you explain engine tier in information server?
Define data aggregation?
What are the functionalities of link partitioner and link collector?
How do you start developing a datastage project?
What is the command line function to import and export the ds jobs?
What is the difference between hashfile and sequential file?
Differentiate between datastage and informatica?
Describe the main features of datastage?
How to manage date conversion in Datastage?
Lookup constraints
Whats difference betweeen operational data stage (ods) and data warehouse?
How can one find bugs in job sequence?
