Answer / bhageerath

src->sq->exp->aggr->tgt

src(col1[int],col2[varchar])

sq(col1[int],col2[varchar])

exp(col1,,col2,v_col1,v_col2,o_col2) {v=variable port, o=output port}

imp:
{ v_col1=col1; v_col2=iif(col1!=v_col1, col2, v_col2||" "||col2); o_col2= v_col2}

aggr(col1,o_col2)

tgt(col1,col2)

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 xml source qualifier transformation in informatica?

0 Answers  

---

I am using Informatica 7.1.1. and i used emails task for getting emails but not able to get emails is there any settings in Informatica installation level?

1 Answers  

---

How informatica recognizes mapping?

2 Answers   CTS,

---

Hi Experts , Can you please help me regarding the below question How to remove first three rows and last three rows in informatica.. thanks and regards Natraj

2 Answers  

---

What is the function of aggregator transformation?

0 Answers  

---

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

---

how can u approach u r client

2 Answers   CTS,

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

Which kind of index is preferred in DWH?

2 Answers  

---

How can yoU improve session performance in aggregator transformation?

8 Answers   TCS,

---

what is the difference between Informatica 7.1 and Abinitio?

1 Answers   TCS,

---