Answer Posted / sunil

hi, my name is sunil.
please send me the dumps for "informatica certified
designer" to my mail id: sunilguptamait@gmail.com

Thanks

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

---

Explain the different dimensions.

965

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1279

---

What is deployment group?

1215

---

what is $$$$?

2157

---

What is a predefined event?

1093

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

976

---

Tell me about MD5 functions in informatica

929

---

What is the difference between writing a joiner query in ANSI style and THETA style?

2380

---

What is xml source qualifier transformation in informatica?

1217

---

Enlist few areas or real-time situations where informatica is required.

1085

---

Explain what transformation and how many are there in informatica?

955

---

explain about unit testing? in real time?

2205

---

What is data caches/ index caches?

1105

---