GeekInterview.com
Series: Subject: Topic:
Question: 6 of 114

Informatica triggering

In informatica v 8.6 One workflow triggers another workflow. How where do we put a distinct clause so that the duplicates are not reflected in the report formed by the second WF. first Wf does a partial load
Asked by: surbhit87 | Member Since Jun-2012 | Asked on: Jun 8th, 2012

View all questions by surbhit87

Showing Answers 1 - 1 of 1 Answers
dspgi

Answered On : Dec 15th, 2012

Your question is not very clear. However, if you mean to say that you are loading the same target table using two different mappings, then here is the answer. You can use any one of the below approaches depending on which one suits your requirement

1) If you are sure that both the mappings might pull common records and load them, then modify your SQ or Filter/ router to load mutually distinct data set

2) You can create the second mapping using Insert/ Update/ Reject logic by using the Update strategy transformation. If the record coming from source already exists in target, then reject or update the new row coming based on your requirement. If the record is new, then insert it.

Hope this helps.

  
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

Question Categories

Abinitio Interview Questions

Analysis services Interview Questions

Data Warehousing Basics

BO Designer Interview Questions

Business Intelligence Interview Questions

Business Objects Interview Questions

Cognos Interview Questions

Data Warehousing Concepts

BO Data Integration

DataStage Interview Questions

ETL Interview Questions

Hyperion Interview Questions

Impromptu Interview Questions

Informatica Interview Questions

MicroStrategy Interview Questions

Reportnet Interview Questions

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.