How will you combine 3 different sources with a single source?

Answer Posted / rkumar.etl

use union transformation or you can write sql override if
you have advance knowledge of table join conditions for the
current database.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can any one give some examples for pre sql and post sql(Except dropping and creating index).

3524


What are pre and post-session shell commands?

751


What do you mean by blocking transformation?

599


What is meant by incremental aggregation?

596


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1539






What are the modules in Power Center

1246


can we override a native sql query within informatica? Where do we do it? How do we do it?

607


While importing the relational source definition from the database, what are the metadata of source that will be imported?

799


What are the components of Informatica? And what is the purpose of each?

628


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

622


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5884


if we have a delimiters at unwanted places in a flat file how can we over come those.

1576


What is a predefined event?

672


Explain target update override in informatica

640


Why do you use Mapping Parameter and mapping variable?

1298