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 the different ways to implement parallel processing in informatica?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How to improve the performance of a session using sorter transformation?
How can we create index after completion of load process?
Lookup transformation, one condition is having SQL override (Empno < 10) and the other condition is Lookup (Sal>1000), which is dynamic. How will u resolve this situation?
How an expression transformation differs from aggregator transformation?
Different circumstance which drives informatica server to expel records?
Do you find any difficulty while working with flat files as source and target?
Can we get 1st record through Informatica(without sequence number).
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What is a router transformation?
In how many ways we can create ports?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Informatica Checkpoints
How to generate or load values in to the target table based on a column value using informatica etl tool.