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
- 23849 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
Can you generate sequence numbers without using the sequence generator transformation?
Whats there in global repository
Explain why we use partitioning the session in informatica?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What are the main features of Oracle 8i with context to datawarehouse?
What is an unconnected transformation?
What is a transaction control transformation?
What is the maplet?
Scheduling properties,whats the default (sequential)
What are batches?
What is the procedure for creating independent data marts from informatica 7.1?
what is the hint? how to use it to reduce the query processing in program?
Tell me about MD5 functions in informatica
Slowly changing dimensions, types and where will you use them
