Interested to Buy Any Domain ? << Click Here >> for more details...
what is rank and dense rank in informatica with any
examples and give sql query for this both ranks
- 4 Answers
- 27632 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunil
dense rank means it is the process of calculating rank for
each group.
deptno rank
10 1
2
3
20 1
2
3
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What is the reusable transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
How to convert multiple rows to single row (multiple columns) in informatica
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Why update strategy and union transformations are active?
What are the reusable transformations?
lookup transformation with screenshots
What is workflow? What are the components of the workflow manager?
What are the new features of informatica 9.x at the developer level?
