how do u decide whether u need to do aggregations at
database level or at Informatica level?
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
What is a mapping?
What is tracing level? How many types of transformations supported by sorted input?
Compare etl & elt?
What is abap? What are idocs?
explain about your project architecture in ssis..could u please send to my mail..vinod.kjvk@gmail.com
How many steps etl contains explain with example?
what is session partitioning?
what is pmrep command?
What are the etl testing operations includes?
Explain the key challenges that you face while performing etl testing.
Can anyone explain me a scenario from banking and finance...more precisely a mapping
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
can cubes contain measures ?
list and discuss two approaches for updation of target table in Informatica and how they are different.
Is hadoop a etl tool?