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
- 14764 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
List the properties of a transaction.
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
What are the advantages of using database?
What is ole db ado?
How to fetch/retrieve the data from hieranchical database and put it into the relational database? for e.g I want to extract the data from IMS DB2 database which is a hierarchical db and load that data into the relational database which is a SQL server.Are there any tools available for directing extracting data from hierarchical db and loading into the relational database (SQL server)?
HOW PASS PARAMETERS FOLLOWING ORDER RPG-CL-RPG?
What is redis good for?
How does non-cluster index functions?
What is Object Oriented model?
How to do performance tunning a database in DB2 V8.2 UDB in linux
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
Explain database partitioning.
can u combine pipeline parallelism and partition parallalism? how and whan?
What do you mean by database?
What is database client?
