Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21659 Views
- I also Faced
- E-Mail Answers
Answer Posted / saumyabrata
1>Use a Sequence Generator Transformation,selet Start value
= 1 and Increment By = 1.
2>Use a Filter Transformation,take the ports Person and
Salary from source qualifier and the NEXTVAL port from
Sequence Generator Transformation into it.Set the filter
condition NEXTVAL = 3.
You are done.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
what is the Default Source Option For Update Strategy Transformation?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
What are different types of transformations available in informatica?
What do you mean by enterprise data warehousing?
How will the document be delivered to me?
define galaxy repository in informatica
What is the need of an ETL tool?
Which transformation is needed while using the Cobol sources as source definitions?
what is the size of your data warehousing?
How to elaborate powercenter integration service?
what is the difference between informatica6.1 and infomatica7.1
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Can you generate sequence numbers without using the sequence generator transformation?
Whats the difference between informatica powercenter server, repositoryserver and repository?
