Interested to Buy Any Domain ? << Click Here >> for more details...
Could any one to tell How to use the Oracle Analytic
functions in Informatica?
- 1 Answers
- 11918 Views
- I also Faced
- E-Mail Answers
Answer / sabyasachi
Some of theOracle Analytical functions are like DENSE_RANK
(), RANK(),CUM_DIST(),CUM_AVG() etc. One get the
fuctionalities of some of these functions such as rank by
using a rank transformation.
For other types of functions one can resort to custom
transformation.
| Is This Answer Correct ? | 2 Yes | 0 No |
What is a shortcut and copy in Informatica and how two are different with each other?
How to join a Flat and Relational Source without using (Joiner, Update and Lookup ) transformations... is it possible? if yes i would like to know how?
SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that
What are the main issues while working with flat files as source and as targets ?
What is dimensional table? Explain the different dimensions.
Difference between Target-based loading and constraint-based loading?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
In how many ways we can create ports?
Explain the tuning lookup transformation - informatica
What is the difference between a connected look up and unconnected lookup?
What is Datadriven?
Does an informatica transformation support only aggregate expressions?
Teradata 
