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
- 24347 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
What all are steps in up gradation of Informatica server?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Design a mapping to load a target table with the following values from the above source?
What is informatica? Why do we need it?
Explain sessions. Explain how batches are used to combine executions?
explain abt ur project architecture?
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What do you mean by channel change?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is joiner change?
What is a dimensional model?
What is data transformation manager process?
What is different between the data warehouse and data mart?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
define galaxy repository in informatica
