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 |
Can you start a batches with in a batch?
can we use mapplet as starting n ending object in mapping
Can you create a flatfile target
what is the difference between repository & Intergration service
how can one eliminate dupliacte data with out using distinct option?
Whats the difference between informatica powercenter server, repositoryserver and repository?
How many transformations can be used in mapplets.
What is the need for an etl tool?
What is the function of look up transformation?
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.
HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?
What are the different types of code pages available in informatica & how to implement it in your project?