what is HISTOGRAM? how to generate statistics?
Answer / louw
A histogram is a graph describing the distribution of a
statistical variable. It can be used describe the nature of
a population or sample.
Is This Answer Correct ? | 0 Yes | 0 No |
State the differences between shortcut and reusable transformation
Explain what is etl process? How many steps etl contains explain with example?
how do u decide whether u need to do aggregations at database level or at Informatica level?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
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?
What is data modeling and data mining?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
what are the reporting tools and difference between them?
What is ROWID explain ?
we hava more than 1000 records. i have to select first 5 record, last 5 record and 5 records from middle of the source. how can i do in oracle as well as in informetica??
when should one create lookup transformation ?
what are the different Reporting and ETL tools available in the market?