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

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

What are different types of transformations available in informatica?

1 Answers  

Do you find any difficulty while working with flat files as source and target?

1 Answers  

list out all the transformations which use cache?

1 Answers   Informatica,

If sal is null then replace it with min(sal). Can any one write a query for this in oracle ? Advance Thanks

7 Answers   Puma,

Enlist the various types of transformations.

1 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table: pls full details

8 Answers   L&T, TCS, UnitedHealth Group, Wipro,

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1 Answers   TCS, Wipro,

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1 Answers   HCL,

how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

For more Informatica Interview Questions Click Here
Categories