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
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to configure mapping in informatica?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Which transformation should we use to normalise the COBOL and relational sources?
What is fact table? Explain the different kinds of facts.
How can you differentiate between powercenter and power map?
Explain sessions?
How to extract the informatica rejected data?
Why union transformation is an active transformation?
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
Explain in detail scd type 2 through mapping.
expain about the tune parameters?
In informatics server which files are created during the session rums?
What is a code page?
what is INFORMATICA TESTING process