When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort
536What are snapshots? What are materialized views & where do we use them? What is a materialized view log?
644In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?
538
What are the etl testing operations includes?
What is partitioning? Explain different types of partitioning?
what is the difference between cubes and package in cognos
What is a materialized view log?
1)Power center server and client on the same machine 2)power center server and client on the different machines What is the basic difference in these two setups and which is recommended ?
What is the difference between project backlog and product backlog?
What is tracing level?
what is the use of server manager?
Mention few test cases and explain them?
what are the data sources extracted from logistics cockpit in sap bw project and what is the requirement for it ?
Do we need an ETL tool? When do we go for the tools in the market?
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.
State the differences between shortcut and reusable transformation
Can there be sub steps of etl steps?
What are the types of data warehouse applications and what is the difference between data mining and data warehousing?