Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bsgsr
mappings can be tuned at diff transformations level.
ex; look up can be optimised by enabling the cache.
aggregator can be optimised by using sorted inout.
filter can be optimised by using it as close as possible
to the sql. so on
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is the meaning of up gradation of repository?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Explain how to import oracle sequence into informatica?
What is informatica powercenter repository?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
What is the format of informatica objects in a repository?
What is different between the data warehouse and data mart?
Differentiate between joiner and lookup transformation?
What are the settings that you use to configure the joiner transformation?
Difference between Data and Index Caches?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Explian the Process of deployment groups in informatica
Is stop and abort are same in informatica?
How to extract sap data using informatica? What is abap? What are idocs?
How to handle decimal places while importing a flatfile into informatica?
