INSERT UPDATE AS UPDATE UPDATE AS INSERT UPDATE ELSE INSERT DELETE TRU

What are the options in the target session of update
strategy transsformatioin?

Question Posted / santhoshi

Answer Posted / santhoshi

INSERT
UPDATE AS UPDATE
UPDATE AS INSERT
UPDATE ELSE INSERT
DELETE
TRUNCATE TARGET TABLE

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1142

How to load last n records of file into target table - informatica

1052

What is a snowflake schema?

975

What is the use of transformation?

980

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

2124

How do you take back up of repository?

1134

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1024

what is song in infrmatica...?

2217

Define joiner transformation?

1028

What is the benefit of partitioning a session?

1159

How to update or delete the rows in a target, which do not have key fields?

1164

Why union transformation is an active transformation?

1034

What are active and passive transformations?

1069

Explain sessions. Explain how batches are used to combine executions?

1005

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2707