Interested to Buy Any Domain ? << Click Here >> for more details...
Which kind of index is preferred in DWH?
- 3 Answers
- 12014 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 |
if suppose i have 3 columns namely 1,2,3 in table a and 1,2,3 in table b Now in table a 1,2 and table b 1,2 columns are having same data.now based on this two columns either data should get inserted or updated. How do i write a sql query to check whether the data is populated correctly or not
What is an expression transformation?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
How can a transformation be made reusable?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
What are the types of schemas we have in data warehouse.
What is IQD file?
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
What is power center repository?
How we can confirm all mappings in the repository simultaneously?
Teradata 
