Define slowly changing dimensions (SCD)?
No Answer is Posted For this Question
Be the First to Post Answer
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.
Identifying the bottlenecks in various components of Informatica and resolving them.
Do we need an ETL tool? When do we go for the tools in the market?
1.Identify and discuss the problems which are occurred during data quality verification for the single-source and multi-source problems. 2.Testing has very important role in DWH. In ETL testing phase, how can we perform the integration testing and regression testing? 3.What are the perquisites of system testing and regression testing in ETL phase?
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?
How to know informatica conslole password??
How can you use an Oracle sequences in Informatica ? You have an Informatica sequence generator transformation also. which one is better to use?
When do we go for the tools in the market?
Difference between flat files and relational sources?
Identifying the bottlenecks in various components of Informatica and resolving them.
Explain and compare etl & manual development?
what happens if the info.server doesn't find the session parameter in the parameter file?