Could any one to tell How to use the Oracle Analytic
functions in Informatica?



Could any one to tell How to use the Oracle Analytic functions in Informatica?..

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

Post New Answer

More Informatica Interview Questions

Can you start a batches with in a batch?

1 Answers  


can we use mapplet as starting n ending object in mapping

2 Answers   TCS,


Can you create a flatfile target

3 Answers   ABC,


what is the difference between repository & Intergration service

1 Answers  


how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,






Whats the difference between informatica powercenter server, repositoryserver and repository?

0 Answers  


How many transformations can be used in mapplets.

0 Answers  


What is the need for an etl tool?

0 Answers  


What is the function of look up transformation?

0 Answers  


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

0 Answers  


HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,


What are the different types of code pages available in informatica & how to implement it in your project?

1 Answers   TCS,


Categories