How many steps etl contains explain with example?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

In the SEQ generator which property has to be set to generate seq No. when the input data is more than the max limit.

3 Answers   Accenture,


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.

0 Answers  


indatastage 8.1 surrgoate key generates seqences numbers write but there is limite value i want to reset the seqence after gettting some highest value like i want o/p like this 1 2 3 4 5 .............10000 1 2 3.........10000

1 Answers   TCS,


what is an ETL or ETT? And what are the different types?

0 Answers  


Explain what is etl process? How many steps etl contains explain with example?

0 Answers  






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.

0 Answers  


where is the cache (lookup, index) created and how can you see it.

0 Answers  


What is the difference between Data Warehousing and Data Mining?

0 Answers  


Compare etl & elt?

0 Answers  


Can anyone explain me a scenario from banking and finance...more precisely a mapping

0 Answers   IBM,


Explain about round-robi?

0 Answers  


What is data cleaning?

0 Answers  


Categories