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
- 7466 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
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 can we improve performance of data stage jobs?
What are the repository tables in datastage?
What is the difference between account and directory options ?
Explain Quality stage?
what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?
Name the command line functions to import and export the DS jobs?
Where the datastage stored his repository?
1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?
What is the difference between operational data stage (ods) and data warehouse?
What are the different layers in the information server architecture?
What are the different kinds of views available in a datastage director?
What are the types of containers?
What is the purpose of interprocessor stage in server jobs?
table actions available in oracle connector?
