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 / tauseef
hai Taueef
As per above requirement my suggestion is
if the sources having similar columns then we go with union
if there is no similar columns add dummy port on all d source and use joiner transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
What is meant by LDAP users?
Different sorts of metadata that stores in the storage facility?
What are the performance considerations when working with aggregator transformation?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the mapping variable usage example in informatica
What is a snowflake schema?
Can anyone tell me the new features in Informatica 9 Version?
How can we handle two sessions in informatica?
how many types of dimensions are available in informatica?
What could be the possible resons of locks by user?
Can informatica load heterogeneous targets from heterogeneous sources?
What does reusable transformation mean?
How do you promote a non-reusable transformation to reusable transformation?
What is an expression transformation in informatica?