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

Post New Answer

More ETL Interview Questions

can u please tell me about ........ how can explain my project before interviewer my projects are insurence domain & sales domain?

0 Answers  


how can i text accracy of ETL migration? i am very new to data warehousing. we are writing ETL scripts using SCRIPELLA tool. how can i test the correctness of data. and we are generating reports using pentaho . is there any easy way to test the pentaho. how can test these ETL scripts written in scriptella? thanks in advance

0 Answers  


how to connect to a flatfile through ftp in informatica

1 Answers   TCS,


Hi my name is kuldeep singh, i have finished my B.E in computer science and engg in 2008. I have worked with accenture for 17 months and because of family problem i left the job in dec 2009.. i was in data ware housing capability. right now i am working in a BPO as technicla support executive,, i want to move to IT again, please suggest me what shuld i do? its been 1 year gap and i am not able to get into IT...please suggest me ...should i go for informatica certification will that help me to get inot IT. please give ur suggestion..my E mail is is singh.kuldeep2004@yahoo.in

0 Answers  


What is etl process? How many steps etl contains?

0 Answers  






What is partitioning? Explain different types of partitioning?

0 Answers  


What is initial load and what is full load?

0 Answers  


What is tracing level and what are the types?

0 Answers  


What is etl process?

0 Answers  


How many steps etl contains?

0 Answers  


what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

0 Answers   Accenture,


what are the types in error loging?

0 Answers   Cap Gemini,


Categories