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 is the DIF format and when we will use in teradata
How to do performance tunning a database in DB2 V8.2 UDB in linux
How does non-cluster index functions?
where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it
What is odm database?
What is a super key?
A lowest level of security by most RDBMS is
What is the function of cluster index?
What are the advantages of normalizing a database.
What do you mean by foreign key and primary key?
can any one explain about normalization forms with clear explanation in interview point of view. thanks for ur answers.
Which database is best to store images?
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)