Interested to Buy Any Domain ? << Click Here >> for more details...
how do u decide whether u need to do aggregations at
database level or at Informatica level?
- 1 Answers
- 3251 Views
- QualTech, I also Faced
- E-Mail Answers
Answer Posted / sajj
If source is flat file its aggregator of course but if source RDMS then we preferred to do it database level if possible
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
diff b/w dwh & data mart diff b/w star schema & snow flake schema diff b/w fact table & dimension table what are the contents in requirement specification what are the docs needed for testing draw ur proj architecture
A mapping contains source table S_Time(stat_year,end_year) target table TIM_DIM(date,day,month,year,quarter) stored procedure transformation: A procedure has two parameters I_end_year and output parameter as O_date ,day , month, year, quarter, If this session is running, how many rows will be available in the target and why?
What is the difference between Data Warehousing and Data Mining?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Explain about round-robi?
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
what are the types in error loging?
What is the difference between project backlog and product backlog?
What is partitioning? Explain different types of partitioning?
how do u set partition points in the mapping?
can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.
Explain do we need an etl tool?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What is etl process. How many steps etl contains explain with example?
how do u extract data from different data sources explain with an example?
