How anyone define the pracical difference between Kimball & Inmon?
How can you say Relational is Normalized one and Data Warehouse i.e Dimensional modeling is De-Normalized one when both model follows the Primary Key Concept in its table to store Data
How to Pivot a table inside informatica?
Allowing data spread across multiple rows to be inserted into a single row in a different table.Col A Col B A 10 B 20After pivoting
Latest Answer: Use a router to denormalize the data and then merge them using a union transfomation. I think this is one of the ways to do it. All the Best. ...
How do you handle the changing no of files as source in the mapping/session which loads the data in a Relational table
What is the difference between OLAP and OLTP?
Latest Answer: OLAP stands for online analytical processing . In this we have access to live data. This process contain historical information to analyze. Data needs to be integrated.We can create reports that are multi-dimensional, supported by time-based analysis ...
What are the different tracing options available? Can tracing options be set for individual transformations?
Explain multidimensional data models and how they are integrated with the architecture you have already designed
Latest Answer: Aggregate tables are pre-computed totals in the form of hierarchical mutidimensional structure.,whereas materliazed view ,is an database object which caches the query result in a concrete table and updates it from the original database table ...
“A dimension table is wide but the fact table is deep” Explain the statement in your own words.
View page << Previous 1 [2] 3 4 5 6 7 8 9 10 Next >>
Go Top
