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,

---

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

---

How do you implement configuration management in Informatica?

1 Answers  

---

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

0 Answers  

---

What do you mean by worklet?

0 Answers  

---

How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)

3 Answers   Atriax,

---

What if the source is a flat-file? Then how can we remove the duplicates from flat file source?

1 Answers  

---

How to implement security measures using repository manager?

0 Answers  

---

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

0 Answers   CTS, FEEE, TCS,

---

According to his methodology what all you need before you build a datawarehouse

0 Answers  

---

What are the mapping paramaters and mapping variables?

1 Answers  

---

wht is full process of Information source to target just like stg to productuon and development

1 Answers   Informatica,

---