Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to capture rejected data by using join stage not for
lookup stage. please let me know

Answer Posted / 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 :)

Is This Answer Correct ?    14 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1035


What are the functionalities of link collector?

1083


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

2459


which r the connectors used in san?

2182


Explain datastage architecture?

1397


What is orabulk stage?

1045


Differentiate between datastage and informatica?

1179


What are the different options associated with dsjob command?

1428


What are the types of views in datastage director?

1761


What is the purpose of interprocessor stage in server jobs?

2230


What is a merge in datastage?

1263


What is the sortmerge collector?

1130


Lookup constraints

1247


What is the roundrobin collector?

1097


What is the difference between orabulk and bcp stages?

1023