without using rank transformation how can we rank items by
using some other transformations
Answer Posted / bhupal
Use sorter t/r first and sort the data by using which port
u want
next use that expression t/r to generate the sequence by
using variable port
next u can use the filter t/r to restrict the data or
required ranks as a output.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What is meant by target load plan?
What is the cumulative sum and moving sum?
How can we use mapping variables in informatica? Where do we use them?
Define mapping and session?
How identifying bottlenecks in various components of informatica and resolving them?
what is diff b/t sorter t/r and agg have the option sorter property...
Enlist the differences between database and data warehouse.
To import the flat file definition into the designer where should the flat file be placed?
What is domain in terms of informatica?
Could you explain what is enterprise data warehouse?
Which means the first record should come as last record and last record should come as first record and load into the target file?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Whats the difference between informatica powercenter server, repositoryserver and repository?
Explain sessions and how many types of sessions are there?