udaya (Guest) on Tuesday, February 21 2012, 10:50 PM

Hi, I am new to informatica

how to load 100 records each time out of 1000 records dynamically?
no filter and seq
       
  •  
    Replied by saurav.mitra on Wednesday, February 22 2012, 01:14 AM · Hide · #1
    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.
Your Response