Answer / bsgsr

i believe this should work.

1) use the first and last functions of aggregate t/tion.
2) use the top option and 1 rank using rank t/tion
similarly last option and 1 rank to get only the first
and lst records.
3) else connect the flat file to filter t/tion. create new
port in filter name it s_no and connect the nextval port of
s.gen and write the contion (assume the file contains 100
records) like s_no=1 or s_no=100

What is the Difference between DSS & OLTP?

5 Answers  

---

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

---

How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

What is joiner change?

0 Answers  

---

Define Update Override?

1 Answers  

---

---

how to run the batch using pmcmd command

2 Answers   Wipro,

---

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,

---

Have you worked with/created Parameter file

0 Answers  

---

how many types transformations supported by sortedinput?

4 Answers  

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

Can we combine a flatfile and a database table using an UNION transformation?

2 Answers   Accenture,

---

how to create user defined function (udf) in informatica

0 Answers   Informatica,

---