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 / nitin
Rank transformation in informatica is like rank() function in oracle. that's why it's giving the next value after the repetition of some values.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
How to handle decimal places while importing a flatfile into informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is meant by active and passive transformation?
What are the different transaction levels available in transaction control transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What are the different versions of informatica?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is a node in Informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
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
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Enterprise data warehouse your projects phase by phase explain?
Explain what is informatica metadata and where is it stored?
As union transformation gives UNION ALL output, how you will get the UNION output?