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

Explain about power designer data modeling software?

0 Answers  


how do u really know that paging to disk is happening while u are using a lookup transform?

0 Answers  


What is data cleaning?

0 Answers  


what is SMP AND MPP?

8 Answers  


what happens if the info.server doesn't find the session parameter in the parameter file?

0 Answers  






can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

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  


what are the concerns of OLTP and DSS systems?

0 Answers   TCS,


we hava a flat file having more than 1000 records and two targets. i have to write first half of the rows into first targets and next half of rows into second target. how can i do in informetica??

1 Answers  


how many maximum session supports to multiload in teradata ??

0 Answers   IBM,


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)

0 Answers   Thomson,


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?

0 Answers  


Categories