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
- 21319 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
list out all the transformations which use cache?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Mention a few design and development best practices for informatica?
What are the different transaction levels available in transaction control transformation?
What are the new features of informatica 9.x at the developer level?
what is the difference between informatica6.1 and infomatica7.1
What is the difference between a connected look up and unconnected lookup?
What will be the approach?
define galaxy repository in informatica
What is joiner transformation?
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 ?
Whats there in global repository
How do you load unique records into one target table and duplicate records into a different target table?
What do you mean by blocking transformation?
How many types of sessions are there in informatica.please explain them?
