What r the type of indexes u generally used in informatica?
Answer Posted / sanjay gupta
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 |
Post New Answer View All Answers
Explain load alternative records / rows into multiple targets - informatica
How to do the error handling of if ur source is flatfiles?
What is a rank transform?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
what are factless facts? And in which scenario will you use such kinds of fact tables.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
What is the format of informatica objects in a repository?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is deployment group?
What is option by which we can run all the sessions in a batch simultaneously?
What are ETL Tools?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is a joiner transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar