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
- 14719 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a database connection string?
What is database schema name?
What is odm database?
What the various ways to tune a teradata query
Why merge statement is used inside the database?
Differentiate between extension & intension?
What is database collection?
Explain data independence & its types.
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
give a simple example of physical and logical data independence
How default key is different from primary key?
Differentiate between unique key and foreign key?
What are the most common databases?
What is a database lookup?
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
