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.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1306


How to configure mapping in informatica?

1225


What are the basic requirements to join two sources in a source qualifier transformation using default join?

1213


Which transformation should we use to normalise the COBOL and relational sources?

1272


What is fact table? Explain the different kinds of facts.

1126


How can you differentiate between powercenter and power map?

1141


Explain sessions?

1140


How to extract the informatica rejected data?

1259


Why union transformation is an active transformation?

1102


HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY

2160


Explain in detail scd type 2 through mapping.

1092


expain about the tune parameters?

2458


In informatics server which files are created during the session rums?

1169


What is a code page?

1220


what is INFORMATICA TESTING process

2334