how to implement dense rank in rank transformation in
Informatica? so that output should be like 1,1,2,3 and not
like 1,2,3,4
- 1 Answers
- 13973 Views
- I also Faced
- E-Mail Answers
Answer / balakrishna
1) Data should be sorted in the order we are expecting the
ranks to be
2)At expression level manipulating variable using the
iteration logic to generate the ranks comparing the current
record with the previous record
| Is This Answer Correct ? | 5 Yes | 2 No |
What does specialization in DBMS mean?
give a simple example of physical and logical data independence
When should you not use firebase?
Explain the table term used in database.
Its possible to use auto increment in oracle or not? If no means why?
what is tkprof tool and how it is used???
What does new grouping sets enables you to do?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
If we execute an query in MLOAD it's ran successfully, my questions is after successfully ran MLOAD. In error tables we can see anything there! is it possible than what are they?
What is the difference between oracle and MS Access?
Difference between sql and mysql?
What are the types of indexes that are present inside a database?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
