Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / shashiall
Swetha answer is correct.Expanding little bit with example.
If there r 3 same salaries..Rank will eliminate the
sequences..try this...rank will come 1,2,3,3,3,6..
To confirm this go to the SQL editor and check this with
Dense rank()function.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Mention few advantages of router transformation over filter transformation.
What if the source is a flat-file?
Explain the features of connected and unconnected lookup.
What are junk dimensions?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Define Pmrep command?
Difference between Target-based loading and constraint-based loading?
Can you generate sequence numbers without using the sequence generator transformation?
What is the commit type if you have a transaction control transformation in the mapping?
Explain the tuning lookup transformation - informatica
What is the fact table?
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 are the tasks that can be performed using sq?
