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 |
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
Datatypes are unlimited,true or false?
What is sqlcode -923 ?
Is database a hardware or software?
What do you mean by database?
Explain entity ?
What are the disadvantages of views in a database?
What is global database name?
What is database schema name?
What are indexes in oracle?
a __________ is a virtual table made up of subset of actual table
Difference between sql and mysql?
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)