without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,

---

What is limitations of truncate and load option

1 Answers   Cap Gemini,

---

Briefly define reusable transformation?

0 Answers  

---

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

---

What is the advantage of informatica?

0 Answers  

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

0 Answers  

---

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers   Accenture, Unisoft Infotech,

---

What is aggregate cache in aggregator transforamtion?

5 Answers  

---

how to declare array in plsql?

1 Answers  

---

Explain target update override in informatica

0 Answers   Informatica,

---

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 process of target load planing?

2 Answers   IBM,

---