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
- 14 Answers
- 22235 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / pushparao
joiner transformation is used for combining the columns of the
different tables with common column horizontally with respect
to data of the columns.
union transformation is used to combined data for the common
columns.
or
simply joiner transformation-->Horizontal collection of the
columns.
union transformation-->vertical collection of rows.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is a surrogate key?
What are the main issues while working with flat files as source and as targets ?
What are the differences between source qualifier and joiner transformation?
What is the use of target designer?
How can informatica be used for an organization?
Can we create a Integration service without a Repository service and vice versa?
Describe data concatenation?
Make a note of the quantity vaults made in informatica?
What is the need of etl tools?
What is the surrogate key?
What is expression transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is dimensional table? Explain the different dimensions.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
