What r the type of indexes u generally used in informatica?
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
Could you explain what is enterprise data warehouse?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What if the source is a flat-file?
can we override a native sql query within informatica? How do we do it?
How can one identify whether mapping is correct or not without connecting session?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What are the different transaction levels available in transaction control transformation?
What is meant by active and passive transformation?
Enterprise data warehouse your projects phase by phase explain?
what is INFORMATICA TESTING process
What is the different lookup cache(s)?
Partition, what happens if the specified key range is shorter and longer
hi real timers . iam waiting for ur reply regarding ETL TESTING
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 change Dynamic to Static or Persistent cache? If so what happens?