Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

I have a flat file, in which i have two fields, emp_id, emp_name. The data is like this, emp_id,emp_name 101,soha 101,ali 101,khan 102,siva 102,shanker 102,reddy. how to merge the names so that my output is like this Emp_id Emp_name 101 Soha ali kahn 102 siva shenkar reddy please provide solution

5 Answers  

How will u find weather dimension table is big in size of a fact table?

1 Answers  

What are the types of schemas we have in data warehouse and what are the difference between them?

0 Answers  

What are the guidelines to be followed while using union transformation?

0 Answers   Informatica,

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

0 Answers  

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?

4 Answers   CTC,

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

How to extract sap data using informatica?

0 Answers  

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers   HG, UST,

In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?

4 Answers   Puma,

How to create Target definition for flat files?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories