Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 14642 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 is dialect in database?
Is storing images in a database a good idea?
Explain the field term used in database.
What is the advantage of varchar2 over char?
What is ase database?
How do I manually create a database?
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What is the difference between a stored procedure and a query?
write a query for the fifth highest salary?
17 Answers IBM, Matlabs, Ramco,
How default key is different from primary key?
What is sharded database?
Which database does facebook use?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
