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??
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 |
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
What is dimensional table?
why union is active transformation?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What are differences between Informatica 7.1 and 6.1
What is the Difference between SetVariable and setmaxvariable in informatica?
What are mapplets? How is it different from a Reusable Transformation?
One source and 3 targets 1st row-1st target 2nd row-2nd target 3rd row-3rd target 4th row-1ist target how will u do?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain the different lookup methods used in informatica?
How can we delete duplicate rows from flat files?