Identifying the bottlenecks in various components of
Informatica and resolving them.
Answers were Sorted based on User's Feedback
Answer / surendra
I know system bottelneck, Source, tarformation, and target.
I think threre are more.
if any one knows please replay back.
| Is This Answer Correct ? | 0 Yes | 1 No |
How to fine tune mappings?
IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is grain of fact?
what are the concerns of OLTP and DSS systems?
give detail on the sales project how many number of dimensions & fact tables are used in projec briefly. how the four fact tables taken in the project.
how do u really know that paging to disk is happening while u are using a lookup transform?
how would u estimate the size of Aggregator transform data and index cache?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
what is pmrep command?
what is the meant by Normalization and de-normalization?
Is hadoop a etl tool?