Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 24457 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
How to load a Dimension ? and how to load a fact table?
What is sequence generator transformation in informatica?
What are the informatica performance improvement tips
What is a joiner transformation and why it is an active one?
Clarify the aggregator change?
What is a sequence generator transformation?
What are the different components of powercenter?
How to load data in informatica ?
What is the cumulative sum and moving sum?
What are active transformations.
Define mapplet?
what is Active lock explain
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
In development project what is the process to follow for an etl developer from day1
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
