Answer / sree

u can override the query in SQt/r
select * from emp where rowid not in ((select min(rowid)
from emp),(select max(rowid) from emp))

Answer / sravanthi

In source qualifier Transformation we can write the
following query.....

select rownum,x.* from (select rownum rn,e.* from emp e ) x
where rn>1 and rn<(select count(*) from emp)

Answer / amedela chandra sekhar

for flat file how can you do it

Answer / babu

Hi A.C Sekhar,
If u r source is flat file,u should take seq/tr and agg/tr
in that take first function and last function after that
take a filter/tr filter condition is seqno !=fno or seqno!
=lno.

MAPPING;

SEQ-->SEQ-->AGG-->FLT-->TRG

PORTS;
NEXTVALUE -->SNO (SEQTR-->AGG)

IN AGG/TR
1.FNO=FIRST(SNO) OUTPUT PORT.
2.LNO=LAST(SNO) OUTPUT PORT.

IF ANY THING WRONG,PLEASE LET CORRECT ME.

THANKS,
BABU.

Answer / santosh kumar sarangi

Hi Babu,

Can you please tell me, which port need to take as group by
port in the aggregator t/r. if you not take any group by
port then by default it is forward only last port.

Thanks & Regards
Santosh

By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?

5 Answers   Keane India Ltd,

---

How would you join a node to the already existing domain?

1 Answers  

---

Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.

2 Answers   TCS,

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

which one is better performance wise joiner or look up

1 Answers   Informatica,

---

What is the fact table?

1 Answers  

---

What is a router transformation?

1 Answers  

---

following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?

7 Answers   Polaris,

---

how to load only the first and last record of a flat file into the target?

8 Answers   CTS,

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

difference between shortcut and reusable transformation?

2 Answers  

---