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
Informatica server and client are in different machines. You run the session from the server manager by specifying the source and target databases. It displays error . You are confident that everything is correct. Then why it is displaying the error?
Identifying the bottlenecks in various components of Informatica and resolving them.
In Which Transformation We Can Use Having Clause In Informatica?
Explain different types of partitioning?
What is initial load and what is full load?
Explain about etl data integration software?
where are the log files generally stored.Can you change the path of the file.what can the path be?
how do u set partition points in the mapping?
List few etl bugs?
What are snapshots?
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?
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.
how does the server recongnise the source and target databases.Elaborate on this
What are the various tools used in etl?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?