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 / sam

1,2,3,3,4,,4,5
1,2,3,3,5,5,7

Is This Answer Correct ?    28 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is pmcmd command?

668


Explain what is informatica metadata and where is it stored?

602


Reusable transformation and shortcut differences

1371


Design a mapping to load the cumulative sum of salaries of employees into target table?

889


Why update strategy and union transformations are active? Explain with examples.

701






What are the types of caches in lookup? Explain them.

547


Differentiate between Load Manager and DTM?

1657


How to generate sequence numbers?

612


How to generate or load values in to the target table based on a column value using informatica etl tool.

604


Differentiate between sessions and batches?

566


How can you generate reports in informatica?

571


How do you change a non-reusable transformation to reusable transformation?

590


can we override a native sql query within informatica? How do we do it?

640


Define joiner transformation?

588


I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1457