Where can i get informatica certification Exam dumps and
details? please forward it to emailid: krisboppana@yahoo.com
Answer Posted / vikram
Can you also email me at : vikramv786@yahoo.com?
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
dimension object created in oracle can be imported in designer?how?
What is a materialized view log?
how many steps are there in etl process?
what is dynamic insert?
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
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?
What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
what is the use of server manager?
What do you understand by the term ‘transformation’?
What are the different etl testing categories as per their function?
Explain different types of partitioning?
what are the types in error loging?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
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.