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.
No Answer is Posted For this Question
Be the First to Post Answer
what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?
Define slowly changing dimensions (SCD)?
what is the difference between shortcut of an object and copy of an object? compare them?
Difference between flat files and relational sources?
Is there any body who works on Pervasive Data Integrator (previously Data Junction)? Is there any scope also?
what is the difference between cardinality and Nullability?
Explain the use lookup tables and Aggregate tables?
how do u really know that paging to disk is happening while u are using a lookup transform?
What is tracing level? How many types of transformations supported by sorted input?
how do u decide whether u need to do aggregations at database level or at Informatica level?
What is partitioning? Explain different types of partitioning?
Is hadoop a etl tool?