What r the type of indexes u generally used in informatica?
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
i have one table like cust_id ph1 ph2 ph3 1002 9290123526 97671927210 9876545232 we use Normalizer wt is o/p? sue normalizer we can generate three tables in single table/
IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????
What will be the approach?
what is inline view?
tell me about your project functionality
what are factless facts? And in which scenario will you use such kinds of fact tables.
Describe the impact of several join conditions and join order in a joiner transformation?
What is the reusable transformation?
If a table contains 100 records we have to fetch 50-100 records from source to target?how
how many types of dimensions are available in informatica?
Discuss the advantages & Disadvantages of star & snowflake schema?
I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com