Interested to Buy Any Domain ? << Click Here >> for more details...
how can u tune u r informatica mapppings
- 2 Answers
- 9530 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 |
In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?
Explain Dataware house architecture .how data flow from intial to end?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment?
Why do we need informatica?
4 yrs etl devloper roles and responsibilities?any body give solutions
in my source i have 100 records, and 3 targets, i want to load 1st record into 1st target,2nd record into 2nd target,3rd record into 3rd target again 4th target into 1st target and vice versa,how to achieve this?
Is it possible to create multiple domains on a single Informatica server?
What is DTM process?
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
What is sq transformation?
what is Active lock explain
What are partitions in informatica and which one is used for better performance?
Teradata 
