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
- 21519 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
Which development components of informatica have the highest usage?
What is dimensional table? Explain the different dimensions.
What is an aggregator transformation?
What is the difference between a connected look up and unconnected lookup?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is parallel processing in informatica?
What is the Rank index port in Rank transformation?
Which transformation is needed while using the Cobol sources as source definitions?
What are Dimensional table?
How to update or delete the rows in a target, which do not have key fields?
How we can create indexes after completing the loan process?
what is the difference between informatica6.1 and infomatica7.1
Why do we need informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Define joiner transformation?
