Hi, I am new to informatica
how to load 100 records each time out of 1000 records dynamically?
no filter and seq
no filter and seq
1 response Add Yours
-
The question is not clear. Do you mean to say, Loading user defined record numbers out of source records to target without using filter and sequence transformation. There are many ways. One way to implement.
1. Take a mapping parameter say $$CNT to pass the number of records you want to load dynamically by changing in the parameter file each time before session run.
2. Next after the source qualifier use an expression transformation and create one output port say CNTR with value CUME(1).
3. Next use an Update Strategy with condition IIF($$CNT>=CNTR, DD_INSERT, DD_REJECT)
Let me know if this is what you were looking for. Apart from that please join the community so that you can receive emails once your question gets answered.