Interested to Buy Any Domain ? << Click Here >> for more details...
Which kind of index is preferred in DWH?
- 3 Answers
- 12186 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri47
It Actually depends on the nature of the Column on which
you are goint to create an index.
Bit Map: If the column is of type Flag means contains 1 or
0.
Binary: If the column cintains numerical values.
Partitions also can be created if column values contains
only some list of values .
| Is This Answer Correct ? | 2 Yes | 0 No |
Can you generate reports in Informatcia?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)
why cant we put a sequence generator or upd strategy transformation before joiner transformation?
Generally how many Fact Tables and Dimensions Table you have used in the Project? Which one is loaded first Fact Table or Dimensions Table into the warehouse? What is the size of the Fact Table and Dimension Table? what is the size of the table and warehouse
What are the different types of olap? Give an example?
What are the session parameters?
How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is a pre-defined event and user-defined event?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
scenario where i can use only concurrent execution of workflow.
Teradata 
