What r the type of indexes u generally used in informatica?
- 2 Answers
- 18414 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / javidakram
b tree and bitmap indexes we r using in informatica. b tree
is low cardinality and bitmap have high cardinality that is
why bitmap index gives better performance.
| Is This Answer Correct ? | 6 Yes | 2 No |
Post New Answer View All Answers
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Separate from a database, an information bazaar, and an information stockroom?
What is a joiner transformation?
Different circumstance which drives informatica server to expel records?
If informatica has its scheduler why using third party scheduler?
What is decode in static cache?
Implementation methodology
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
What is informatica etl tool?
Describe the impact of several join conditions and join order in a joiner transformation?
What are the mapping parameters and mapping variables?
What the difference is between a database, a data warehouse and a data mart?
what is unit testing?tell me proceedure
Which version configuration tool used in ur project?
