If the values in a row are 1,2,3,3,4,,4,5 then how a rank
transformation can rank these values
Answer Posted / kondeti srinivas
explanation for sam.
sam has given currect ans 1,2,3,3,5,5,7
upto 1,2,3 is fine after 3 again itput is 3 for that rank
t/f give rank as 3 after rank t/f skip 4 ranks becasue it
already given rank for repeaded value and for null values
it rank will not give any rank
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are multi-group transformations?
What is meant by a domain?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is Index Caches size?
How to load data in informatica ?
What is Session and Batches?
Define mapping and session?
how we can load rejected record's at run time?(not through bad files)
How to generate sequence numbers without using the sequence generator transformation?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Define sessions in informatica etl?
Is it possible to define a single node as a Gateway node as well as worker node?
What is incremental aggregation?
Can we create a node as a gateway node and the same node can be assigned to a grid?