Answer Posted / vdrona
Mapping can be tuned by identifying the following bottlenecks in order shown below.
1. Target Bottlenecks
2. Source Bottlenecks
3. Transformation/Mapping Bottlenecks
4. Session Bottlenecks
5. System Bottlenecks
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What are the restrictions of union transformation?
is it possible to index the data in cache of lkp transformation ?
Define the various join types of joiner transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is a connected transformation?
What is the format of informatica objects in a repository?
When do you use sql override in a lookup transformation?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
How many input parameters can exist in an unconnected lookup?
what are factless facts? And in which scenario will you use such kinds of fact tables.
how to load rows into fact table in data warehouse
Design time, run time. If you don't create parameter what will happen
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What is union transformation?
Enlist the advantages of informatica.
