What are the types of Data Warehouse applications?
No Answer is Posted For this Question
Be the First to Post Answer
What are the different ways to deploy the code in informatica?
1 Answers IBM, Saama Tech, Wipro,
What are the steps involved in etl process?
Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks
Difference between flat files and relational sources?
What is partitioning? Explain different types of partitioning?
what are the concerns of OLTP and DSS systems?
What is full load & incremental or refresh load?
Define slowly changing dimensions (SCD)?
what are the different Reporting and ETL tools available in the market?
what is the difference between OLTP database and data warehousing database?
What is a staging area? What is the purpose of a staging area?
list and discuss two approaches for updation of target table in Informatica and how they are different.