Answer Posted / ranvir thakor

WE can use B-Tree index where data cardinality is high and
many DML operations are performed and have many distinct
values. while Bitmap will use when have low cardinality and
less distinct value like gender column(M/F) or value does
not update frequently.

What is enterprise data warehousing?

1029

---

Explain the features of connected and unconnected lookup.

922

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2058

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1308

---

What are the issues you have faced in your project? How did you overcome those issues?

2348

---

Which are the different editions of informatica powercenter that are available?

1026

---

Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks

8059

---

EXL informatica Questions

1362

---

in reporting we add some new objects,how we get the count of the newly added objects to the report

2178

---

What are the differences between a connected lookup and unconnected lookup?

1060

---

Differentiate between reusable transformation and mapplet.

1075

---

can you please explain me pre session and post session options?

7524

---

What is the sql query overwrite in source qualifier in informatica

1071

---

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2043

---

What do you mean by worklet?

1051

---