Interested to Buy Any Domain ? << Click Here >> for more details...
which transformation should we use to get the 5th rank
member from a table in informatica?can we achieve this in
sql?
- 6 Answers
- 10494 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yaseen
As my knowledge we can write as
select distinctsal from emp A where 5 =
(select count(distinctsal) from emp B where A.sal <= B.sal)
Plz correct me if I am wrong
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is sequence generator transformation in informatica?
How can you increase the performance in joiner transformation?
what is unit testing?tell me proceedure
What are the different options available for update strategy?
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
Make a note of the quantity vaults made in informatica?
How do you convert single row from source into three rows into target?
Describe the impact of several join conditions and join order in a joiner transformation?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
Explain lookup transformation source types in informatica
Explain your project of banking domian.
What's the layout of parameter file (what does a parameter file contain?)?
Explain pushdown optimization $pushdownconfig parameter - informatica
How union transformation is used?
