How to list Top 10 salary, without using Rank Transmission?
Answer Posted / abhilash
do following steps
1.in source qualifier override the query with
"order by salary desc"
2. use seq gen tr on it and give column name as "sid"
3. next use filter tr. in that write condition like "sid<=10"
Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
What is joiner transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
How can we create index after completion of load process?
How can we delete duplicate rows from flat files?
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 pushdown optimization and types in informatica
How can we remove the duplicates from flat file source?
What is native users?
Enlist few areas or real-time situations where informatica is required.
Please let me know how to make encryption and decryption with example?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Explain the shared cache and re-cache?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Define update strategy?