Answer / ande

we have bitmap index, b-tree index, function based index,
reverse key index and composit index. we will use bitmap
index in DWH
Regards,
ande

Answer / ghouse

to load the data into the fact table b tree index is created
and bit is used where the cordinality of the coloumn is very
low i.e(in dwh-denormalised one)(OLAP)

Is it possible to update the target table with PK?

1 Answers   TCS,

---

in my source table i want to delete first and last records and load in between records into target? how can it possible?

3 Answers   HCL, Thomson Reuters,

---

How can you recover the session in sequential batches?

1 Answers  

---

In session log thier should not be a single error how will u do

3 Answers   HCL,

---

What is mapplet in informatica?

0 Answers  

---

---

What are the Differences between connected and unconnected lookup?

6 Answers   TCS,

---

can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

---

How to delete the data in the target table after loaded.

3 Answers   TCS,

---

I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  

---

If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,

---

What is polling in informatica ?

1 Answers   TCS,

---