Answer / guest

BY USING FIRST FUNCTION, TO GET THE 1ST RECORD,
TO GET THE LAST RECORD , SIMPLY USE AGGREGATE
TRANSFORAMATION IN THIS DO NOT APPLY GROUP BY FUNCTION BY
DEFALUT IT WILL GENERATE LAST RECORD
OR
USE RANK TRANS
IN =>PROPERTIES NO OF TOP RANKS:1
NO OF BOTTOM RANKS:LAST RECORD

Answer / chandrasekar

I took the EMP table and we can use the below query in the
SQL override,

select * from emp where rownum=1 union select *
from emp where rowid=(select max(rowid) from
emp);

it will work.

Answer / kiran

take two rank transformations and take reusable sequence
generator connect the next value to both rank transformations
and in the rank transformations properties for the first one
take top and number of ranks as 1 for the second take bottom
and number of ranks 1 at the last take two instances of tgt
connect the ranktrans to two instances

write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,

---

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

---

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

2 Answers  

---

what is junk dimension

4 Answers   Cap Gemini,

---

what is upstream and downstream transformation?

7 Answers  

---

---

How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6

1 Answers   Cap Gemini,

---

What is the fact table?

0 Answers  

---

what is left outer join?

3 Answers   L&T,

---

How to eliminate duplicates in FF and oracle both

3 Answers   CSC,

---

how can i invoke pmcmd in command line prompt

1 Answers  

---