Interested to Buy Any Domain ? << Click Here >> for more details...
if we have certain records,if i need to get 5 th rec for the
first time to the target,when i run it for next time,i need
to get 6th rec...like that it should process.what wil be the
procedure to achieve it??
- 1 Answers
- 6274 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / zer0
I guess this should work ........
Source --> SQ --> Exp --> Filter --> Exp --> Target
|
|
SG
Firstly create a mapping variable say $$count and give it
the default value 5.
Create a port in Expression say Srno. and connect the
sequence generator to it (so that it will mark the rownums).
Then in Filter place the condition Srno = $$count
In the second Expression create an extra port and give it
the value SETCOUNTVARIABLE($$count) (this will increment
the mapping variable).
Next time the job runs it will take value of $$count as 6
and so on ........
Kindly revert if this worked ........
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
How does a rank transform differ from aggregator transform functions max and min?
Differences between connected and unconnected lookup?
What is mapping debugger?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
What are the differences between oltp and olap?
Why is sorter an active transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the prerequisite tasks to achieve the session partition?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What are mapplets?
Which is the t/r that builts only single cache memory?
What is workflow? What are the components of workflow manager?
What is flashback table ? Advance thanks
