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
- 14849 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 connection string?
What are different types of joins used in?
What is database server and how it works?
What is relational database with example?
what is difference between delete and truncet ?
Explain data independence & its types.
Explain partial key?
What is database and its types?
What is database schema name?
What is meant by distributed system?
Explain storage manager?
What do you mean by foreign key and primary key?
-
Oracle (3253) - 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)
