hOW CAN WE DELETE A RECORD OR TRUNCATE IN TARGET TABLE
USING SQL T/R ?

Answer Posted / pooja

write sql query in tgt property .. per sql & post sql

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how many types of dimensions are available in informatica?

752


how tokens will generate?

1939


What is joiner transformation?

756


As union transformation gives UNION ALL output, how you will get the UNION output?

868


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2067


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1855


What all join we can perform in LOOKUP transformation?

753


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

1921


Why update strategy and union transformations are active?

805


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1664


Briefly describe lookup transformation?

792


What is status code in informatica?

789


Explain the etl program with few examples.

753


What do you mean by blocking transformation?

779


What is the difference between a connected look up and unconnected lookup?

762