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
how would u estimate the size of Aggregator transform data
and index cache?
117
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?
288
explain the methodology of Data Warehousing?(Polaries)
128
Is there any body who works on Pervasive Data Integrator
(previously Data Junction)? Is there any scope also?
235
what is session partitioning?
104
what is pmrep command?
145
HI,
Anybody is having informatica Dumps,if it there Can u send
to my mail id :sathesh.cool@gmail.com
63
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?
6
how would u estimate the size of Lookup transform data and
index cache?
106
what are the session parameters? How do u set them?
108
Difference between flat files and relational sources?
96
what is session partitioning?
77
when will use SQL override in a lookup transformation?
240
Can u access a repository created in previous version of
Informatica?
203
how would u estimate the size of Aggregator transform data
and index cache?
89
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?
along with your userid / name. ThanQ
Site Map
