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
- 13959 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 |
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
How to implement database security?
What is sqlcode -923 ?
What is the difference between primary key, foreign key and candidate key?
Clipper / DBF error
A lowest level of security by most RDBMS is
What is database bounce?
What are different types of joins used in?
What are the various ways to execute a query in teradata?
What is a trace file?
sparse lookup and where its options we find in OCI and db2?
-
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)
