Explain do we need an etl tool?
No Answer is Posted For this Question
Be the First to Post Answer
What is full load & incremental or refresh load?
Identifying the bottlenecks in various components of Informatica and resolving them.
Dear All, Can anyone tell me that from where i can get Power Center 8.5 S/W for Linux and how can i install Power Center 8.5 or any 7.x series on Linux Platform. Thanks in advance
how do u implement configuration management in Informatica?
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and surrogate keys K1,K2,K3,K4 (a) write a sql statement to populate Fact table F1 (b) Design a mapping in Informatica for loading of fact table F1.
What are the key benefits of ETL Testing?
how do u set partition points in the mapping?
Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code
how does the server recongnise the source and target databases.Elaborate on this
Difference between flat files and relational sources?
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.
what is session partitioning?