Answer / subbuchamala

SRC1, SRC2=====>JOIN====>TGT

in JOIN stage, take full outer join.
in Filter/Transformer stage, give condition as SRC1.KEY is null then unmatched records from SRC2.
SRC2.KEY is null then unmatched record from SRC1.

Answer / 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.

Answer / ankit gosain

Hi,

You can achieve the unmatched records from Primary and
Secondary with the help of Full Outer Join using Join Stage.

source1----->Join Stage------>Transformer------>Target
|
|
|
source2-----------

Full Outer Join on Source1.key=Source2.key

Now, in Transformer Stage, write in constraint tab for
source1, <any coulum of source2> IsNull, to collect the
unmatched records of source1.
&, write in constraint tab for source2, <any coulum of
source1> IsNull, to collect the unmatched records of
source2.

If you have any other doubt or query, mail me on
ankitgosain@gmail.com

Cheers,
Ankit :)

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

In my source i have 10 records but i want 11 records in target. How can i acheive this in Server jobs.

2 Answers   IBM,

---

CAN ANY ONE TELL ME THE ARCHITECTURE OF DATASTAGE CLEARLY....

2 Answers   Wipro,

---

if the source file is CID,CCODE,CONNDATE,CREATEDBY 0000000224,1000,20060601,CURA 0000000224,2000,20050517,AFGA 0000000224,3000,20080601,TUNE 0000000225,1000,20020601,CURA 0000000225,2000,20050617,AFGA 0000000225,3000,20080601,TONE AND TARGET is oracle following are the validations cid loaded with unique records leading zeors has to be deleted while loading cid in target load only customer who got early connected to company conn_date should be loaded into oracle date format cid datatype is varchar2 in target conn_date is data datatype ccode is varchar2 0000000224,1000,20060601,CURA 0000000224,1000,20060601,CURA

2 Answers  

---

---

How rejected rows are managed in datastage?

0 Answers  

---

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

---

What are the partition techniques available in your last project?

1 Answers  

---

What is exact difference between Parallel Jobs and server Jobs..

7 Answers   IBM,

---

what are the types of nodes

4 Answers   HCL, TCS,

---

WAT TYPE OF PL/SQL QUERRYS USED IN DATASTAGE

0 Answers  

---

in a job of 20 one job is very slow due to that entire job is slow how can u find out which job is slow?

1 Answers   IBM,

---