Which kind of index is preferred in DWH?
- 3 Answers
- 10923 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 |
difference between shortcut and reusable transformation?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
Which transformation can be created only as reusable transformation but not as non-reusable transformation?
if we have input eno 1,2,3,1,2,3 year 2001,2002,2003,2001,2002,2003 and sal 10000,20000,30000,20000,30000,40000 ex-output eno totsal 1 30000 2 50000 3 70000
What is intricate mapping?
Can anyone please distinguish what is Inner join and Outer join
What is the need of building a data warehouse?
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can u stop a batch?
What are the different types of Type2 dimension maping?
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
Teradata 
