how can we load starting with 11th record of a table from
source to target

Answer Posted / krish

take expression in exp take variable port(v1.......v1+1)and
take output port(in that give v1)send this o/p port to
router give the condition as v1>11.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain sessions. Explain how batches are used to combine executions?

782


How to load the data from a flat file into the target where the source flat file name changes daily?

793


How to generate sequence numbers using expression transformation?

828


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1009


Briefly describe lookup transformation?

783


What is meant by pre and post session shell command?

852


What is rank transform?

750


How we can create indexes after completing the loan process?

961


Differences between connected and unconnected lookup?

856


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1421


What is the difference between stop and abort in informatica

865


How an expression transformation differs from aggregator transformation?

820


What is deployment group?

879


What is union transformation?

741


if we have a delimiters at unwanted places in a flat file how can we over come those.

1800