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
- 6239 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
What are the settings that you use to configure the joiner transformation?
How to extract the informatica rejected data?
Explain sessions and how many types of sessions are there?
What differs when we choose the sorted input for aggregator transformation?
What are the different lookup cache(s)?
What is informatica powercenter repository?
can we override a native sql query within informatica? Where do we do it?
Informatica settings are available in which file?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is incremental aggregation?
How many ways a relational source definition can be updated and what are they?
Explain pushdown optimization $pushdownconfig parameter - informatica
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
generate date / time dimension in informatica
Is stop and abort are same in informatica?
