Generally how many Fact Tables and Dimensions Table you
have used in the Project?
Which one is loaded first Fact Table or Dimensions Table
into the warehouse?
What is the size of the Fact Table and Dimension Table?
what is the size of the table and warehouse
Hi i am new to Informatica. I have few question's in
Informatica. Can any one respond, it will be appricaited.
Q.Is Flat File Contains the Dynamic Cache?
please tell me any easy ways of testing the Data warehouse
project. In my project we are not using any tools for ETL.
we are writing scripts in SCRIPTELLA.
And we using Pentaho tool for Reporting
How can i test all these. please tell me ASAP.
thanks in adavance
236
Can u access a repository created in previous version of
Informatica?
204
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?
292
Describe the function and untility of the most difficult
SAS macro that you have written.
158
Two different admin users created for repository
are________and_________.
90
what are different storage options supported by oracle ?
141
What project,model,parameter maps,namespace and database
definitions.......
what these are all contains?
what are differences b/w them?
In Report page i have three types like (List,Cross
tab,Chart), using Conditional Block i need only type of
Report (Chart)at run time.How to do this I need The Complete
Steps to do this?
109
how to connect source to db?generally what r stages u used?
how to find the data is having delimiter format?
what is different between sequential batch and concurrent
batch and which is recommended and why?
190
what is universe testing(not mention check integrity)
122
What is mean by tuning the report?
149
What is the difference between Section and Section using
Master/Detail in Cognos 8 Report Studio? I tried these both
options many times on lists and crosstabs, but dint find any
difference. So please give the answer in detail with example.
164
what is the difference between cardinality and Nullability?
98
what is the difference between querystudio in reportnet and
cognos8
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
