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

What do you mean by filter transformation?

0 Answers  

What are the challenges of Dataware housing in the future?

2 Answers   HP,

Which transformation should u need while using the cobol sources as source defintions?

2 Answers  

Hi all,Can any one provide me Informatica Designer Certification dumps.I need all three papers dumps.If any one has these dumps then plz send it on this id:- nagesh.jujjuru@yahoo.com Thanks in advance

1 Answers  

What are the designer tools for creating tranformations?

1 Answers   Informatica,

in my source table one of column contains the data like vishnraju@gmail.com,suresh@yahoo.com,krishna@hotmail.com these records i need to send in target table as below format. vishnuraju,suresh,krishna

5 Answers   Cap Gemini,

What are the advantages of informatica?

0 Answers  

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

1 Answers   Wipro,

What do you understand by SOA of Informatica?

0 Answers  

What happens if we dont select data driven option?

2 Answers   Zensar,

How the informatica server increases the session performance through partitioning the source?

1 Answers  

While importing the relational source definition from the database, what are the metadata of source that will be imported?

0 Answers   Informatica,