Which kind of index is preferred in DWH?
- 3 Answers
- 10901 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 |
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
In real time scenario where can we use mapping parameters and variables?
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
difference between shortcut and reusable transformation?
How to jion 2 tables, without using any condition?
in which situations do u go for sequence generator ?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Do you have to change the reject file b4 using reject loader utility.
i have 2 session s1 execute s2 load first session fail what is the reason?
What are the different options available for update strategy?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
In which conditions we can not use joiner transformation (Limitaions of joiner transformation) ?
Teradata 
