how do u decide whether u need to do aggregations at database level or at Infor

how do u decide whether u need to do aggregations at
database level or at Informatica level?

Question Posted / jakki

1 Answers
3325 Views
QualTech, I also Faced
E-Mail Answers

how do u decide whether u need to do aggregations at database level or at Informatica level?..

Answer / 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

More ETL Interview Questions

what is the use of structures?how many nodes can u create in a structure?

0 Answers

What is a mapping, session, worklet, workflow, mapplet?

0 Answers

what are the concerns of OLTP and DSS systems?

0 Answers

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?

0 Answers

Two different admin users created for repository are________and_________.

1 Answers

WHY CANT WE SEE THE DATA IN DATASET

1 Answers IBM,

What is the main difference between peek stage and copy stage

2 Answers

how to connect to a flatfile through ftp in informatica

1 Answers TCS,

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

0 Answers

Explain the key challenges that you face while performing etl testing.