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.
how do u estimate the depth of the session scheduling queue?
Where do u set the number of maximum concurrent sessions
that Informatica can run at a given time?
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 an ETL or ETT? And what are the different types?
131
how do u set partition points in the mapping?
136
can be used COM component in Informatica ?
143
how would u estimate the size of Aggregator transform data
and index cache?
90
what is the use of server manager?
103
how do u extract data from different data sources explain
with an example?
131
what is pmrep command?
146
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?
136
How can you use an Oracle sequences in Informatica ? You
have an Informatica sequence generator transformation also.
which one is better to use?
177
1.Identify and discuss the problems which are occurred
during data quality verification for the single-source and
multi-source problems.
2.Testing has very important role in DWH. In ETL testing
phase, how can we perform the integration testing and
regression testing?
3.What are the perquisites of system testing and regression
testing in ETL phase?
10
what is session partitioning?
107
what is the difference between date cache and lindex cache?
82
Identifying the bottlenecks in various components of
Informatica and resolving them.
89
what is pmrep command?
299
5. How many repositories can we create in Informatica?
6. What is surrogate key?
7. What is difference between Mapplet and reusable
transformation?
8. What is aggregate awareness?
9. Explain reference cursor?
10. What are parallel querys and query hints?
11. DWH architecture?
12. What are cursors?
13. Advantages of de normalized data?
14. What is operational data source (ODS)?
15. What is meta data and system catalog?
16. What is factless fact schema?
17. What is confirmed dimension?
18. What is the capacity of power cube?
19. Difference between PowerPlay transformer and power play
reports?
20. What is IQD file?
21. What is Cognos
script editor?
22. What is difference macros and prompts?
23. What is power play plug in?
24. Which kind of index is preferred in DWH?
25. What is hash partition?
26. What is DTM session?
27. How can you define a transformation? What are different
types of transformations in Informatica?
28. What is mapplet?
29. What is query panel?
30. What is a look up function? What is default
transformation for the look up function?
31. What is difference between a connected look up and
unconnected look up?
32. What is staging area?
33. What is data merging, data cleansing and sampling?
34. What is up date strategy and what are th options for
update strategy?
35. OLAP architecture?
36. What is subject area?
37. Why do we use DSS database for OLAP tools?
293
what is dynamic insert?
101
how would u estimate the size of Lookup transform data and
index cache?
100
Can u access a repository created in previous version of
Informatica?
Site Map
