how to work with mapplet designer in informatica?

7 Answers  

---

connected and unconnected lookups?

4 Answers  

---

Consider a Phone Log table as below. It records all phone numbers that we dial in a given day. SOURCE_PHONE_NUMBER DESTINATION_PHONE_NUMBER CALL_START_DATETIME 1234 4567 01/07/2011 10:00 1234 2345 01/07/2011 11:00 1234 3456 01/07/2011 12:00 1234 3456 01/07/2011 13:00 1234 4567 01/07/2011 15:00 1222 7890 01/07/2011 10:00 1222 7680 01/07/2011 12:00 1222 2345 01/07/2011 13:00 Please provide an SQL query to display the source_phone_number and a flag where the flag needs to be set to Y if first called number and last called number are the same and N if the first called number and last called number are different. Desired Output: Source Number Is_Match 1222 N 1234 Y

2 Answers   Amazon,

---

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

AT the max how many transformations and mapplets can we use in a mapping ?

1 Answers   Cap Gemini, Cognizant,

---

---

What is lookup transformation?

0 Answers  

---

What are the measure objects?

0 Answers  

---

Hey I am net to informatica? Can any one explain me step by step How scd will work ?

1 Answers   Infosys,

---

Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,

---

What is the Rankindex in Ranktransformation?

7 Answers  

---

How to load the data from a flat file into the target where the source flat file name changes daily?

0 Answers   Informatica,

---

checkout and checkin in informatica 8.6

3 Answers   TCS,

---