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?
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
how can i text accracy of ETL migration? i am very new to
data warehousing. we are writing ETL scripts using
SCRIPELLA tool. how can i test the correctness of data.
and we are generating reports using pentaho . is there any
easy way to test the pentaho. how can test these ETL
scripts written in scriptella?
thanks in advance
Hello all,
Source Table(Flat File):- Target Table(Flat File):-
Date Date
01/08/2008(DD/MM/YYYY) 01/08/2008
02/08/2008
03/08/2008
04/08/2008
05/05/2008
My requiremnt is this. I need to do it by informatica,Plz
tell me how can i do it?
Thanks
Dear All,
Can anyone tell me that from where i can get Power Center
8.5 S/W for Linux and how can i install Power Center 8.5 or
any 7.x series on Linux Platform.
Thanks in advance
what is the meant by Normalization and de-normalization?
36
Identifying the bottlenecks in various components of
Informatica and resolving them.
47
what is the use of server?
43
what is the main role of FI on business
68
how do u set partition points in the mapping?
54
how do u decide whether u need to do aggregations at
database level or at Informatica level?
33
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?
53
A session S_MAP1 is in Repository A. while running the
session error message has displayed `server hot-ws270 is
connect to Repository B`.what does it mean?
52
what are business components in Informatica?
42
can cubes contain measures ?
33
Can u access a repository created in previous version of
Informatica?
35
how can i text accracy of ETL migration? i am very new to
data warehousing. we are writing ETL scripts using
SCRIPELLA tool. how can i test the correctness of data.
and we are generating reports using pentaho . is there any
easy way to test the pentaho. how can test these ETL
scripts written in scriptella?
thanks in advance
59
what is data modeling?
30
what is different between sequential batch and concurrent
batch and which is recommended and why?
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
