What is the difference between Bitmap and Btree index?
Answer Posted / sarvesh
bit map incdex is an index in which the data will be in the
form of bites,by this we can retrieve the data very fastly
btree index is an index which is default index as
normal indexes.
| Is This Answer Correct ? | 14 Yes | 13 No |
Post New Answer View All Answers
What are the uses of etl tools?
How to do unit testing in informatica?
In informatics server which files are created during the session rums?
How do you load only null records into target? Explain through mapping flow.
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Can informatica load heterogeneous targets from heterogeneous sources?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
Write the advantages of partitioning a session?
What are the conditions needed to improve the performance of informatica aggregator transformation?
server hot-ws270 is connect to Repository B. What does it mean?
What is Index Caches size?
In informatica workflow manager, how many repositories can be created?
Define the various join types of joiner transformation?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
Did u used latest transformations of 8.6.0? for what?