Answer / raj

NewLookUpRow

Answer / moorthy g

NEWLOOKUPROW

Note: We can't edit the port:

NEWLOOKUPROW = 0 (No Changes)
NEWLOOKUPROW = 1 (Insert)
NEWLOOKUPROW = 2 (Update)

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,

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

Explain the etl program with few examples.

0 Answers  

---

Can i create a lookup table without cache.

7 Answers   iGate,

---

What is Test load plan? Let us assume 10 records in source, how many rows will be loaded into target?

3 Answers   Logica CMG,

---

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

Two different admin users created for repository are ______ and_______

1 Answers  

---

draw informatica architecture 8.6 ?

0 Answers   Cognizant, TCS,

---

What is incremental aggregation and how it is done?

8 Answers   JPMorgan Chase, TCS,

---

Can we get 1st record through Informatica(without sequence number).

0 Answers  

---