sravan kumar

• Dec 3rd, 2006

 

By Using Look up transformation we can look up A flat file.When u click Look up transformation it shows u the message.Follow that.

Test load is nothing but checking whether the data is moving correctly to the target or not.

Prasad

• Dec 27th, 2006

 

Test load is the property we can set at the session property level by which Informatica performs all pre and post session tasks but does not save target data(in RDBMS target table, it writes the data to check the constraints but rolls it back). If the target is flat file then it does not write anything in the file. We can specify number of source rows to test load the mapping. This is another way of debugging the mapping without loading the target.