How to delete the (flat file) data in the target table after
loaded.

Answer Posted / james

whatever data u want to delete from target table,simply go
with truncate option.

Is This Answer Correct ?    1 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a grid in Informatica?

840


design of staging area?

1813


I have a flat file, want to reverse the contents of the flat file

912


Please let me know how to make Data masking in informatica..

1479


What are connected or unconnected transformations?

868


Where do we use mapping variables in informatica?

817


What is persistent lookup cache?

789


What are the different ways to implement parallel processing in informatica?

1115


How might you approve all mappings in the archive all the while?

814


How do you load first and last records into target table?

926


How to update source definition?

857


What are ETL Tools?

856


Define the various join types of joiner transformation?

775


What is a dimensional model?

750


What is aggregator transformation in informatica?

739