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
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 are different types of joins used in?
What is dialect in database?
What are indexes in oracle?
how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)
how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.
Explain the table term used in database.
Write the major components of a Database Management System?
Under which circumstance should you create an index on a table?
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
What is difference between clustered, non-clustered and unique index?
Is storing images in a database a good idea?
Can you tell any two advantages of stored procedures?
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)