Could any one to tell How to use the Oracle Analytic
functions in Informatica?
- 1 Answers
- 11493 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 did you do in source pre load stored procedure
What do you mean by enterprise data warehousing?
why do we go for update strategy tr in SCD rather using the session properties?
Explain incremental aggregation in informatica
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
I need an oracle query for convert Char to Integer?. Can any one help me how to do this?
What is xml source qualifier transformation in informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
replace multiple spaces with single space.
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
In informatics server which files are created during the session rums?
Teradata 
