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?
CAN ANY ONE SEND ME THE CODE FOR THE BELOW
1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD
DISPLAY OUT PUT AS "323237232"
2). NEED TO ONLY "COMPANY.COM" FROM EMAIL
FILED "TEST@COMPANY.COM"
we have 1 source table containing 100 records. now we have
to transfer first set of 1-10 (i.e1-10) records to one
target table and another set of 1-10(11-20) records to
other target table and continue like that till 100th record
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
Can u access a repository created in previous version of
Informatica?
203
dimension object created in oracle can be imported in
designer?how?
102
Two different admin users created for repository
are________and_________.
89
how do u decide whether u need to do aggregations at
database level or at Informatica level?
85
what is pmrep command?
145
Is there any body who works on Pervasive Data Integrator
(previously Data Junction)? Is there any scope also?
237
can cubes contain measures ?
76
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?
69
what are the reporting tools and difference between them?
150
what is session partitioning?
116
what is the main role of FI on business
141
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?
7
what is different between sequential batch and concurrent
batch and which is recommended and why?
189
how would u estimate the size of Lookup transform data and
index cache?
97
what is an ETL or ETT? And what are the different types?
129
what are Lookup caches options? Including persistent caches.
72
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.
118
what is the difference between shortcut of an object and
copy of an object? compare them?
169
what is the use of server manager?
102
how do u handle performance issues in Informatica . where
can u monitor the performance ?
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
