Can anyone tell me the new features in Informatica 9 Version?

0 Answers   Syntel,

---

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,

---

What is the difference between informatica 8.x and 9.x

1 Answers   Wipro,

---

What are differences between Informatica 7.1 and 6.1

3 Answers  

---

What is the advantage of informatica?

0 Answers  

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

How many ways you create ports?

1 Answers  

---

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

---

Can you copy the session to a different folder or repository?

2 Answers  

---

WHAT IS FACT TABLES?

2 Answers  

---

where to store informatica rejected data? How to extract the informatica rejected data?

0 Answers  

---

what is curr val use for in sequence generator?

2 Answers   Emphasis,

---