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

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

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  

---

Triggers,VIEW,Procedures

0 Answers   CTS,

---

how can you generate sequence number using only the sequential file stage?

3 Answers   TIAA CREF,

---

Is there no issue when you try to convert a NOt null column in nullable and vice versa in aggregator styage and transformer stage? When I tried i got the warnings but in a running code I can see such type of scenarios. Please explain

2 Answers  

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

I have 100 records how can I load at a time from the single time

1 Answers  

---

What is the diff between sort performed at sort stage and the stream sort performed at the input of few stages in DS Enterprise edition?

1 Answers  

---

How do you reject records in a transformer?

0 Answers  

---

Have you used Unstructured data?

0 Answers   CTS,

---

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,

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---