i have different sources in different databases ,that
sources may be
100 tables i want to load these tables in to single target
how to
pearform the task

Answer Posted / rachana

Use a Joiner Transformation to join the tables and load
into single target. Joiner tarnsformation can join
heterogenous sources

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is informatica metadata and where is it stored?

604


Is it possible to define a single node as a Gateway node as well as worker node?

677


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1579


What all are steps in up gradation of Informatica server?

633


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1570






what is $$$$?

1752


What is a predefined event?

682


Explain lookup transformation source types in informatica

713


What is a joiner transformation and why it is an active one?

590


Why do we need informatica?

569


In what scenario we use to improve session performance by pushdown optimization?can any one give example?

5282


What is transformation?

681


What is the Rank index port in Rank transformation?

684


What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1652


What is the function of union transformation?

631