Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
577Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
571Post New Data Warehouse General Questions
What is index awareness in universe?
Explain what is the difference between stop and abort?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
How to join 3 database like flat file, oracle, db2 in informatrica?
What is the difference between olap and oltp?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is freehand sql?
What are session timeout and application timeout?
What is the difference between power center & power mart?
What are Non-additive facts?
What are non-additive facts in detail?
What are the key columns in Fact and dimension tables?
Explain dimension table ?
Why null values are mapped as 0 in fact tables?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?