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
Answer Posted / prashant
Hello Bsgsr,
thats is one of poosible sol, we can do it only when all
the source's are Relational.
what in case if the source is a mix of Homegeneous and
Hetrogeneous ???
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between Active and Passive transformation?
Which transformation is needed while using the Cobol sources as source definitions?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
Explain sessions and how many types of sessions are there?
What is informatica?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Define the various join types of joiner transformation?
What are connected or unconnected transformations?
What is InformaticaPowerCenter?
How to join three sources using joiner?
In warehouses how many schemas are there?
what are factless facts? And in which scenario will you use such kinds of fact tables.