Informatica tips

New key generation through Dynamic Lookup:
If you are using an override query in dynamic look up, add a union query with maximum of the key.