Interested to Buy Any Domain ? << Click Here >> for more details...
What r the type of indexes u generally used in informatica?
- 2 Answers
- 18948 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / sanjay gupta
Normally we use two types of indexes in informatica.
Btree Index
Bitmap Index
Bitmap Index gives better performance than Btree Index.
| Is This Answer Correct ? | 10 Yes | 1 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to load a Dimension ? and how to load a fact table?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the benefit of session partitioning?
Slowly changing dimensions, types and where will you use them
What is target designer and target load order?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How do you load unique records into one target table and duplicate records into a different target table?
What are the prerequisite tasks to achieve the session partition?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
can we override a native sql query within informatica? How do we do it?
