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
- 22234 Views
- Altisource, TCS, I also Faced
- E-Mail Answers
Answer Posted / bsgsr
after reading the above answers i find one is left joining
the tables in the database itself rather than joinng them
in the session using 99 joiners. it would also increase
performance.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is an unconnected transformation?
What is a pre-defined event and user-defined event?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
can we override a native sql query within informatica? Where do we do it?
What is Index Caches size?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Why sorter is an active transformation?
How many input parameters can exist in an unconnected lookup?
Repository user profiles
Explain lookup transformation is active in informatica
what is index?how it can work in informatica
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Define update strategy?
