Answer / jd

this can be done using FIRST_VALUE() AND LAST_VALUE()

check the below link for more information

http://netezzamigration.blogspot.com/2014/10/lastvalue-and-firstvalue-best-example.html

Answer / kivi

first value and last value...

for more info ref 

http://etltechsolutions.wordpress.com/2014/10/12/last_value-and-first_value-best-example/

I have a file with data comming as 1,x1,x2,x3 2,a1,a2 3,b1,b2,b3,b4 1,y1,y2,y3 2,c1,c2,c3 3,d1,d2 my out put should be as follows x1,x2,x3,a1,a2,<null>,b1,b2,b3,b4 y1,y2,y3,c1,c2,c3,d1,d2,<null> Please let me know how can we acheive this in informatica Thanks in advance

4 Answers  

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,

---

Difference between Target-based loading and constraint-based loading?

0 Answers  

---

---

What are the connected or unconnected transforamations?

2 Answers  

---

what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  

---

How do we implement materialized view?when to use materialized view?

1 Answers   TCS,

---

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

---

Is it possible to update the target table with PK?

1 Answers   TCS,

---

How to create or import flat file definition in to the warehouse designer?

0 Answers   Informatica,

---

How is union transformation utilized?

0 Answers  

---