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
- 11853 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to create or import flat file definition in to the warehouse designer?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
How can repository reports be accessed without sql or other transformations?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How do you load alternate records into different tables through mapping flow?
Informatica Checkpoints
What are the new features of Power Center 5.0?
Which means the first record should come as last record and last record should come as first record and load into the target file?
How do you load unique records into one target table and duplicate records into a different target table?
what is the Default Source Option For Update Strategy Transformation?
how to load dimension table and fact table. plz tell me the steps.
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
