GeekInterview.com
Series: Subject: Topic:
Question: 41 of 726

How to run a single pipeline within a mapping?

Suppose in my mapping 3 pipelines are there from source to target and i want to run the middle pipeline only.
Asked by: sri.dwh85 | Member Since May-2011 | Asked on: May 10th, 2011

View all questions by sri.dwh85

Showing Answers 1 - 3 of 3 Answers
Raghunath

Answered On : Aug 5th, 2011

There is no solution in informatica for run paricular pipeline in mapping... session will execute complete mapping not an single pipeline ... so better to create new mapping for middle pipeline...

  
Login to rate this answer.
SEHAJ SHANGARI

Answered On : Aug 18th, 2011

In designer.
Select mapping tab
There is a property target load plan
Select the source qualifier and the target which u want to run the first n place it in first position. Followed by other pipelines

Yes  1 User has rated as useful.
  
Login to rate this answer.
Suhel Shaikh

Answered On : Nov 24th, 2011

Example; If we have two pipelines in a single mapping then whichever pipeline you do want to run just add 1=2 in the SQ override as a last statement.And create two sessions for the same mapping and add this statement to the SQ of one source which you don't want to run.It will run the other one.

  
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.