how can u tune u r informatica mapppings
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
how did u understand business requirement?
What is the meaning of decode in informatica?
What is native users?
how do u move the code from development to production?
how to load only the first and last record of a flat file into the target?
How will you check the bottle necks in informatica? From where do you start checking?
ename,deptcount vamshi,3 kumar,5 krish,8 in o/p i want vamshi record 3 times kumar record 5 times like wise what is the logic.? give the entire logic plz
if i have records like these (source table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk 10001 gfhgdgh 10002 hjkdghkfh the target table should be like these by using expression tranformation. (Target table) rowid name 10001 gdgfj 10002 dkdfh 10003 fjfgdhgjk xx001 gfhgdgh xx002 hjkdghkfh (that means duplicated records should contain XX in there rowid)
how do u move the code from development to production?
what is polling?
Different qualification between a related rotate toward the sky and isolates look upward?