Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...



I want load the data into target with out 1st and last record.

Answers were Sorted based on User's Feedback



I want load the data into target with out 1st and last record...

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))

Is This Answer Correct ?    11 Yes 1 No

I want load the data into target with out 1st and last record...

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)

Is This Answer Correct ?    1 Yes 0 No

I want load the data into target with out 1st and last record...

Answer / amedela chandra sekhar

for flat file how can you do it

Is This Answer Correct ?    0 Yes 0 No

I want load the data into target with out 1st and last record...

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.

Is This Answer Correct ?    2 Yes 2 No

I want load the data into target with out 1st and last record...

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

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

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,


Categories