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

In which circumstances that informatica server creates Reject files?

2 Answers  

---

What are Rapid changing dimensions?

1 Answers  

---

Explain the shared cache and re-cache?

0 Answers  

---

what is the -ve test case in your project.

0 Answers   CTS, TCS,

---

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how

7 Answers   TCS,

---

---

How to recover the standalone session?

2 Answers  

---

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

---

Explain one complecated mapping?

3 Answers   Fidelity, Wipro,

---

how many tasks are there in informatica ?

15 Answers   DELL, iGate, TCS,

---

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

---

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  

---

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

1 Answers  

---