Mapping Design Tips
Miscellaneous Tips:
1. Use UPDATE strategy in the mapping unless the mapping always does an ‘Insert’ or always does an ‘Update’.
2. Take a daily backup of the repository during the development phase.
3. Use Mapplets wherever possible
4. Source files with different record types should be sorted as per record type prior to be processed by Informatica. Source files should be split into multiple files (by transaction types or record type.) where appropriate.
Miscellaneous Tips:
1. Use UPDATE strategy in the mapping unless the mapping always does an ‘Insert’ or always does an ‘Update’.
2. Take a daily backup of the repository during the development phase.
3. Use Mapplets wherever possible
4. Source files with different record types should be sorted as per record type prior to be processed by Informatica. Source files should be split into multiple files (by transaction types or record type.) where appropriate.
Comments (0)
- No comments yet.
