What is the difference between bitmap and btree index?
Answers were Sorted based on User's Feedback
Answer / sneha latha.r
Bitmap index is used for repeating values.
ex: Gender:male/female
Account status:Active/Inactive
Btree index is used for unique values.
ex: empid.
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / amarnath
Bitmap index is used on low cardinality columns i.e less
distinct columns eg: Gender: Male/Female.
B-tree is used on high cardinality colums
eg: Student first name
Is This Answer Correct ? | 8 Yes | 1 No |
Explain lookup transformation in informatica
empno sal 1 8000 2 9000 3 8000 4 1000 how to get highest sal wise rankings in rank t/r.
how to join the two flatfiles using the joiner t/r if there is no matching port?
what we require for D.modelling?
what is the drillup & drill down?and use of the drill up and drill down?
HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.
What are the mapings that we use for slowly changing dimension table?
How will you convert rows into columns or columns into rows
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?
What is version control in informatica ? Advance thanks
Enlist few areas or real-time situations where informatica is required.