GeekInterview.com
Series: Subject: Topic:
Question: 44 of 725

How to connect in mapping from target to any other transformation in Informatica ?

I have two target tables,so i want to make Union of both the target,so please let me know about this
Asked by: shaikiliyas | Member Since Mar-2011 | Asked on: Apr 15th, 2011

View all questions by shaikiliyas

Showing Answers 1 - 3 of 3 Answers
KOTI

Answered On : Oct 31st, 2011

It is not possible to keep transformation after target.. We need to create two mappings. In second mapping we need to take those two targets as sources for second mapping..

  
Login to rate this answer.
Sreedhar Lokaray

Answered On : Nov 3rd, 2011

I think your question is how to merge the records from two targets after they got loaded? If this is your question then first import the two target tables as source tables. Complete the mapping to load the two targets. In the same mapping drag the two sources and connect to union transformation as you required. In the Menu bar click Mapping -> Target Load Plan... In the Target Load Group Order dialog box select the one to load the targets first.

I think this answers your question.

  
Login to rate this answer.
santanu

Answered On : May 11th, 2012

Make two flows in the same mapping:
flow 1: load both the targets
flow 2: use both the targets as the source and use SQL override to join the tables. Then load them into a single table

  
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.