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
- 21140 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 meant by active and passive transformation?
What is sorter transformation?
How would you join a node to the already existing domain?
Sequence generator, when you move from develoment to production how will you reset
explain abt ur project architecture?
What is a mapplet/worklet in informatica?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain about Informatica server process that how it works relates to mapping variables?
What is the different lookup cache(s)?
Explain what are the different types of transformation available in informatica.
where to store informatica rejected data?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What does update strategy mean, and what are the different option of it?
What are the advantages of using informatica as an etl tool over teradata?
