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

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

605


Which transformation should we use to normalise the COBOL and relational sources?

748


Describe the impact of several join conditions and join order in a joiner transformation?

649


What is resilience time?

655


Is stop and abort are same in informatica?

572






permutations of mapplet

2042


Different sorts of metadata that stores in the storage facility?

561


Where is metadata stored?

623


Can we create a Integration service without a Repository service and vice versa?

728


What is the use of source qualifier?

674


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1753


What is sequence generator transformation in informatica?

625


What are the main features of Oracle 8i with context to datawarehouse?

1682


How to generate or load values in to the target table based on a column value using informatica etl tool.

613


What is a standalone command task?

656