Interested to Buy Any Domain ? << Click Here >> for more details...
how can u tune u r informatica mapppings
- 2 Answers
- 9302 Views
- CTS, I also Faced
- E-Mail Answers
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 many ways are there to do 'remove duplicate records in informatica'?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
How do u identify or filter out a 0 byte file available in a folder by using UNIX command?
i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0
without table how to come first record only in oracle?
Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?
i have a wf i want to run this very day 3 time every 3 hours how can you scheduled that?
What is an expression transformation in informatica?
how to use incremental load?
What does “tail –f” command do and what is its use as an Informatica admin.
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
what is size of u r database?
Teradata 
