dimension object created in oracle can be imported in
designer?how?


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

Post New Answer

More ETL Interview Questions

1. if lookup tr is giving poor performamence. what u do. 2. i have emp,dept table. i want output ename,empno,dname,max(sal). 3. can any one tell me project flow in real time scenario. please send me mail any queries and answers my mail id is yaparala@gmail.com

2 Answers   HCL, iGate,


what is dynamic insert?

0 Answers  


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,


Compare etl & elt?

0 Answers  


what are the concerns of OLTP and DSS systems?

0 Answers  






what are the reporting tools and difference between them?

0 Answers  


Which transformation we use to convert 'NA' to 'Not Available'

0 Answers  


what is meant by drill through?(Mascot)

1 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 we cannot use sorter Transformation. if we use then we will not get correct data?

0 Answers  


What are cubes and olap cubes?

0 Answers  


how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

0 Answers  


Categories