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

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

Question Posted / james

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

Please Help Members By Posting Answers For Below Questions

scenario where i can use only concurrent execution of workflow.

3254

How to update source definition?

1140

How do you take back up of repository?

1206

What is the sequence generator transformation in informatica?

1261

What are the various types of transformation?

1239

What is meant by a domain?

1186

What are the data movement modes in informatica?

1207

Performance tuning in UNIX for informatica mappings?

2621

expain about the tune parameters?

2456

What are the types of presistent cache in look up tr.

2104

Under what conditions selecting sorted input in aggregator will still not boost session performance?

1127

What is informatica etl tool?

1055

what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

2104

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1946

What are the popular informatica products?

1054