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
- 11750 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
What are the types of lookup transformation?
Explain in detail about scd type 1 through mapping.
What is dimensional table?
Different circumstance which drives informatica server to expel records?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Describe data concatenation?
What is resilience time?
What is confirmed fact in dataware housing?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
What is a rank transform?
What is persistent lookup cache?
What do mean by local and global repository?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain your project of banking domian.
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
