Interested to Buy Any Domain ? << Click Here >> for more details...
Which kind of index is preferred in DWH?
- 2 Answers
- 10551 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ande
we have bitmap index, b-tree index, function based index,
reverse key index and composit index. we will use bitmap
index in DWH
Regards,
ande
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / ghouse
to load the data into the fact table b tree index is created
and bit is used where the cordinality of the coloumn is very
low i.e(in dwh-denormalised one)(OLAP)
| Is This Answer Correct ? | 1 Yes | 1 No |
What is aggregate awareness?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is dimensional table?
MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104 MY REQUIRMENT IS NAME ID VENKATESH 101 RAJESH 102 SIVA 103 SWATHI 104 PLEASE PROVIDE ME THE SOLUTION
How do schedule a workflow in Informatica thrice in a day? Like run the workflow at 3am, 5am and 4pm?
Filter transformation in the condition one of the data is NULL would the record be dropped.
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.
What is a stored procedure transformation?
If I am having 6 flat files in data. How can you load the data at a time
what is target update override and when we use it?
What is the Router transformation?
Teradata 
