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 is normalization? explain 1st NF, 2nd NF, 3rd NF

1 Answers   SunGard,

---

Why we need XMLs?

3 Answers   IBM,

---

In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?

1 Answers  

---

What is intricate mapping?

0 Answers  

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---

---

How do you do error handling in Informatica?

1 Answers  

---

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---

How do we come to know the Source data/file is ready/Updated in the source location, when the session is scheduled for @12:00AM and ready to run its job ? or Can we schedule the session, when the source is updated in source location without any time constraint?

2 Answers   iFlex, TCS,

---

What is an expression transformation?

0 Answers  

---

"Change cache" in Informatica ?

2 Answers  

---