Answer / sanjay gupta

Normally we use two types of indexes in informatica.
Btree Index
Bitmap Index

Bitmap Index gives better performance than Btree Index.

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.

what are objects in data warehouse?

2 Answers   Mind Tree,

---

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

---

how the server recognises , if the session fails after loading the 100 records in to the target

2 Answers   TCS,

---

what is the difference between Informatica7.1 & informatica 8.1

4 Answers  

---

Router T/R is active but some people are saying it is also passive which is exactly right?

5 Answers  

---

How can informatica be used for an organization?

0 Answers  

---

What is the need of an ETL tool?

0 Answers   Informatica,

---

Can you create a flatfile target

3 Answers   ABC,

---

what are challenges that you faced in testing? give solution to it?

1 Answers  

---

how can i invoke pmcmd in command line prompt

1 Answers  

---

Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---