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

Can you explain tagbatch restructure operator?

0 Answers  

---

i have the source from Uk,north america how can i pass the data two tables based on the locations

2 Answers  

---

Name the different sorting methods in datastage.

0 Answers  

---

How can we select pr retrieve the particular row in dataset by using orchadmin command?

1 Answers   IBM,

---

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

0 Answers  

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

---

i have a some records eno ename acono amount 1001 suresh sbi101 12000 1001 suresh sbi101 14000 1001 is dublicata how can i remove duplicate?

4 Answers  

---

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

---

how can we do null handling in sequential files

2 Answers   Reliance,

---

What is the purpose of pivot stage?

0 Answers  

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,

---