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
Enlist some properties of sessions.
4 yrs etl devloper roles and responsibilities?any body give solutions
How would you copy the content of one repository to another repository?
What is the difference between Active and Passive transformation?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What is InformaticaPowerCenter?
How can one identify whether mapping is correct or not without connecting session?
What is the difference between router and filter?
what is size of u r database?
How can we improve session performance in aggregator transformation?
Explain the features of connected and unconnected lookup.
What is rank transform?
Is it possible to create multiple domains on a single Informatica server?
what is INFORMATICA TESTING process