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

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

How do you register plug-ins?

0 Answers  

---

How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?

1 Answers   Infosys, TCS,

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

---

If you want to use the same piece of code in different jobs, how will you achieve it?

0 Answers  

---

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.

1 Answers  

---

How to find value from a column in a dataset?

0 Answers   TIAA CREF,

---