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 different between sequential batch and concurrent batch and which is recommended and why?
what are Lookup caches options? Including persistent caches.
What is tracing level? How many types of transformations supported by sorted input?
What is the difference between round-robin partitioning and hash partitioning?
What are the different Lookup methods used in Informatica?
What is cube grouping?
How many steps etl contains?
What is data cleaning?
Explain do we need an etl tool? When do we go for the tools in the market?
List few etl bugs?
What is a mapping?
Can there be sub steps of etl steps?
Is hadoop a etl tool?
What are cubes and olap cubes?
Hi Guys, my requirement is to load 1 yr data from oracle to teradata database through abinitio etl graph.i need to schedule this as a monthly job.but i want to load 12 month data for the first time and from second time it should load last (recent) month data and delete 13th month data. For example For the first time it should load 201208 to 201108 data, second time it should delete 201108 month data and load 201209 month data. I developed garph to load 12 month data ,but i don't know how to handle above requirement as am new to abinitio. i greatly appreciate you help.Thank You.