Answer Posted / shiva
To store the data in a particular dimension
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
what is degenerated dimension?
What is the way to execute pl/sql script using informatica mapping?
How big was your fact table
how we can load rejected record's at run time?(not through bad files)
Explain the scenario which compels informatica server to reject files?
Explain the pipeline partition with real time example?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
how to load rows into fact table in data warehouse
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How are indexes created after completing the load process?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
what is diff b/t sorter t/r and agg have the option sorter property...
How you know when to use a static cache and dynamic cache in lookup transformation?
What is lookup change?
How can a transformation be made reusable?
