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
How many steps etl contains?
In Which Transformation We Can Use Having Clause In Informatica?
what are the different Reporting and ETL tools available in the market?
in sap bw project at what scenario generic extraction is used and why explain and also tell why you used calendar day option explain?
what is session partitioning?
Give a way in which u can implement a real time scenario where data in a table is changing and u need to look up data from it.How will u configure the look up transform for this purpose?
What is full load & incremental or refresh load?
What are cubes and olap cubes?
Give the benefits of data integration suite?
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
What is Data Vault???
working of line item dimension......pls,tell overall flow