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
- 6352 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 is the function of aggregator transformation?
What is the sequence generator transformation in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
difference between repository database and repository service?
What are session parameters ? How do you set them?
What is a grid in Informatica?
How do you manage the Parameter files while migrating your data from one environment to another environment?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
How we can create indexes after completing the loan process?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
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
What is informatica worklet?
Define the various join types of joiner transformation?
I have a flat file, want to reverse the contents of the flat file
What if the source is a flat-file?
