what is mapping optimization? wat are the techniques for tat
Answer Posted / satya
*Use sorted input in Aggretator transformation to decrease
the use of aggregate caches.If you use a Filter
transformation in the mapping, place the transformation
before the Aggregator transformation to reduce unnecessary
aggregation.
* We can use the Source Qualifier transformation to filter
as an alternate way to filter rows.
* Perform joins in a database when possible rather using a
joiner transform
*Adding an index to the columns used in a lookup condition
if you have privileges to modify the database containing a
lookup tables.
these are some simple techniques
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How to start a workflow using pmcmd command?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are Dimensional table?
What are the features of complex mapping?
Differentiate between source qualifier and filter transformation?
Which are the different editions of informatica powercenter that are available?
What are the types of schemas we have in data warehouse.
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is the difference between informatics 7x and 8x and what is latest version?
What is complex mapping?
What are ETL Tools?
Is there any way to read the ms excel datas directly into informatica?
Explain the code page compatibility?
What is workflow? What are the components of workflow manager?
Which development components of informatica have the highest usage?