1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is the necessity to use update strategy?(except for
updates)

Question Posted / mehul.thakur

Answers were Sorted based on User's Feedback



what is the necessity to use update strategy?(except for updates)..

Answer / gazulas

man!! u can flag the record as insert or reject.

Is This Answer Correct ?    2 Yes 0 No

what is the necessity to use update strategy?(except for updates)..

Answer / raghav

Following options are available for update strategy :

DD_INSERT : If this is used the Update Strategy flags the row for insertion. Equivalent numeric value of DD_INSERT is 0.
DD_UPDATE : If this is used the Update Strategy flags the row for update. Equivalent numeric value of DD_UPDATE is 1.
DD_DELETE : If this is used the Update Strategy flags the row for deletion. Equivalent numeric value of DD_DELETE is 2.
DD_REJECT : If this is used the Update Strategy flags the row for rejection. Equivalent numeric value of DD_REJECT is 3.

so u can use update strategy for delete, reject or insert.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

What are the data movement modes in informatcia?

3 Answers  

explain abt joiner t/r?

1 Answers   IBM,

If i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???

5 Answers   Wipro,

How the informatica server increases the session performance through partitioning the source?

1 Answers  

Hi, source data is col1 values are 5,6,7 col2 are 3,2,1 col3 are 8,9,10 and i want to get target as col1 5,6,7 col2 1,2,3 col3 8,9,10 how to do this one?

6 Answers  




what is data driven in informatica

5 Answers   IBM,

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  

State the limitations where we cannot use joiner in the mapping pipeline?

0 Answers  

What is diff joiner and lookup

4 Answers   BirlaSoft,

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

0 Answers  

What is data caches/ index caches?

0 Answers  

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

For more Informatica Interview Questions Click Here
Categories