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
- 14766 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 a database lookup?
What is the difference between primary and candidate key?
what is transaction state, buffer management, shadow paging
Give the syntax of exception handling used in DBMS?
Why do we need distributed database?
What is a super key?
Under which circumstance should you create an index on a table?
What are the tools used for backup and ticketing?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
What is ole db ado?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
Explain alternate key?
-
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)
