GeekInterview.com
Series: Subject: Topic:
Question: 24 of 444

Conditional load of records in Datastage

Source has sequential file stage in 10 records and move to transformer stage it has one output link 2 records and reject link has 5 records ? But i want remaining 3 records how to capture
Asked by: Interview Candidate | Asked on: Aug 24th, 2011
Showing Answers 1 - 3 of 3 Answers
tina

Answered On : Oct 21st, 2011

Add a third output link and make the filter condition as negation of first output link and reject link. All the records that do not match the filter condition of first output or filter condition of reject would be passed to the third link.

  
Login to rate this answer.
anil_k_nayaka

Answered On : Jan 25th, 2012

View all answers by anil_k_nayaka

In the transformer Stage Constraints we can define the constraints where this records can get to which link so that the missing records can get catched.

  
Login to rate this answer.
Shirisha

Answered On : Oct 10th, 2012

You can choose O.W option in constraints, so remaining records you will get.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.