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??
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 validations that you can perform in oracle and in informatica ? Advance Thanks
Explain pushdown optimization $pushdownconfig parameter - informatica
How might you approve all mappings in the archive all the while?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is persistent lookup cache?
How does a rank transform differ from aggregator transform functions max and min?
What are the data movement modes in informatica?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is joiner transformation in informatica?
r u done any partitions in ur project?
What is the need for an etl tool?
Informatica settings are available in which file?
In development project what is the process to follow for an etl developer from day1
How might one distinguish in the case of mapping is right or not without associating session?
The question was on time stamp. what is the difference between HH and HH24 when to use when.