In a table, 4 person having same salary. How to get Third
person record only?
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 a snowflake schema?
define galaxy repository in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Why update strategy and union transformations are active? Explain with examples.
Is it possible to define a single node as a Gateway node as well as worker node?
Enlist few areas or real-time situations where informatica is required.
What are the performance considerations when working with aggregator transformation?
What is a predefined event?
what is the size of u r source(like file or table)?
Quickly characterize reusable change?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Write the different tools in the workflow manager?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is resilience time?
What is sorter transformation?