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

How are the sources and targets definitions imported in informatica designer?

1096

Is it possible to create multiple domains on a single Informatica server?

1231

How do you set a varible in incremental aggregation

1880

What are the features of complex mapping?

1151

Explain scd type 3 through mapping.

982

What is meant by target load plan?

960

What are Dimensional table?

1053

How can we handle two sessions in informatica?

1027

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2119

What is the sql query overwrite in source qualifier in informatica

1077

What all are steps in up gradation of Informatica server?

1042

What are the static cache and dynamic cache in informatica?

1180

Global and Local shortcuts. Advantages.

2032

difference between repository database and repository service?

1143

Differentiate between router and filter transformation?

1004