Answer / karn khera

Use FULL OUTER JOIN....the non matching records will be having null values....after join put a transformer and collect rejected data by Isnull() function..... cheers :)

Answer / vz

We can not capture the reject data by using join stage.
For that we can use transformer stage after join stage.

Answer / prasad

Instead of Transformer, use filter stage, it will gain performance

In Filter stage: use two Links

1st link: Where(clause)=column_name<>''

2nd link: Where=column_name='' (Reject data)

U will get O/P

Which algorithm you used for your hashfile?

0 Answers  

---

cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle

3 Answers   TCS,

---

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

0 Answers  

---

Differentiate between datastage and datastage tx?

0 Answers  

---

Which warehouse using in your datawarehouse

0 Answers   IBM,

---

how to transfer file from one system to another system in unix? which cmd to be use?

5 Answers   Cap Gemini,

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

0 Answers   CTS,

---

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

---

CAN WE DO HALF PROJECT IN PARALLEL JOBS AND HALF PROJECT IN SERVER JOBS?

2 Answers   Infosys,

---

6) my sorce d1 d2 d1 d2 d1 d3 d2 d1 my target tartget 1 d1 2 d1 3 d1 4 d1 target2 1 d2 2 d2 3 d3 Target 3 1 d3 Can any body send me answer this is argent requierment

3 Answers   TCS,

---

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---