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
- 5314 Views
- IBM, I also Faced
- E-Mail Answers
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 |
There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping
To achieve the session partition what r the necessary tasks u have to do?
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?
what is the location of parameter file in informatica?
when informatica 8 series released ?
Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?
What is the function of look up transformation?
What is a surrogate key?
without using emailtask how will send a mail from informatica?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
How to improve the performance of Aggregate transformation?
What is a taget load order?
Teradata 
