How can you use an Oracle sequences in Informatica ? You
have an Informatica sequence generator transformation also.
which one is better to use?


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

Post New Answer

More ETL Interview Questions

what make u disappointmnets in u r career

0 Answers   Infosys,


Hi please try to reply with answer. my mail id is raghu.1028@gmail.com. if the source is having millions of records, but having theree target tables. As per user the first record need to insert into first target and second record in to a second target and third into third target, similarly the process needs to repeat?

5 Answers  


What are the names of the layers in etl?

0 Answers  


what are the different forms of normalization?

2 Answers  


how do u set the size of block buffer?

1 Answers  






what are Lookup caches options? Including persistent caches.

1 Answers  


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?

1 Answers  


Do we need an etl tool?

0 Answers  


what is the use of structures?how many nodes can u create in a structure?

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  


how to load the data to fact table?

0 Answers  


What is the difference between round-robin partitioning and hash partitioning?

0 Answers  


Categories