I want capture UnMatched records from Primary source and secondary source in JOIN stage?
Answer Posted / subhash (subbuchamala)
SRC1, SRC2====>JOIN====>TGT
in JOIN stage, select the full outer join.
in the Filter/Transformer stage, give condition as SRC1.KEY is null then unmatched records from SRC2.
SRC2.KEY is null then unmatched record from SRC1.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Describe routines in datastage? Enlist various types of routines.
What are iconv and oconv?
What are the important features of datastage?
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 ?
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
What is the difference between odbc and drs stage?
In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name
What are stage variables, derivations and constants?
How to create a file using vi editor? 2)how to delete a file in vi editor? 3)How to connect the server datastage to unix? what r the command lines we r using? 4)30 jobs r runnig in unix i want to find out my job. how to do this? give me command?
How to reverse the string using SQL?
What is ds designer?
What is size of a transaction and an array means in a datastage?
WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE
How do u convert the columns to rows in datastage?
Enlist various types of routines in datastage.