Identifying the bottlenecks in various components of
Informatica and resolving them.
Answer Posted / 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 |
Post New Answer View All Answers
What is a lookup table in etl?
how do u estimate the number of partitions that a mapping really requires? Is it dependent on the machine configuration?
what is an ETL or ETT? And what are the different types?
how do u really know that paging to disk is happening while u are using a lookup transform?
What do you understand by the term ‘transformation’?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
what are Lookup caches options? Including persistent caches.
How to increase performance without changing anything in mapping.( In prod)
what are the reports developed in sap bw project and what is the requirement for developing it?
When do we analyze the tables? How do we do it?
What are your responsibilities as an etl tester?
What is Data Vault???
Explain do we need an etl tool?
what is the main role of FI on business
HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com