If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

---

how to sort date field in infomatica?

2 Answers  

---

what type of transformation is not supported by mapplets?

4 Answers   CTS,

---

What is Cognos script editor?

0 Answers   Cognizant,

---

What happens if you increase commit intervals and also decrease commitExplain grouped cross tab?

2 Answers  

---

---

difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,

---

How can you define user defied event?

0 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,

---

i have a table with name field. i,e name Shankar prabhakar nitikripa so no if a occures 3 times in name then it will go to tgt A if b occures 3 times in name then it will go to tgt b .. if z occures 3 times in name then it will go to tgt z

1 Answers   HCL,

---

normalizer transformation

3 Answers   CTS,

---

What is metadata reporter?

1 Answers   Informatica,

---

What is DTM process?

4 Answers  

---