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 is the use of structures?how many nodes can u create in a structure?
what is the indicator file and where it is used?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
Assume u have a 24CPU machine with 24GB RAM, suggest how u would like to configure Informatica ,like number of concurrent sessions, RAM requirements etc,max partitions that u would permit per mapping.
what are the different forms of normalization?
Explain about etl data integration software?
how do u identify the changed records in operational data?
What are the differences between sql override and update override?
how do u decide whether u need to do aggregations at database level or at Informatica level?
how would u estimate the size of Lookup transform data and index cache?
Explain and compare etl & manual development?
What is the difference between Data Warehousing and Data Mining?