Interested to Buy Any Domain ? << Click Here >> for more details...
wht target override?wht advantages it has compare to target
update?
- 2 Answers
- 13693 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / siva
Target Update (by using Update strategy) will work only
when we have the Primary key in Target. Update override
will happen based on this key.If we don't have the Pkey
Update override will not work.
To overcome the above issue..If our Target is not having
any key column or if we want to update the Target based on
a column other than PKey column then we need to go for
Target Update override option available in Target
properties.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
What are the performance considerations when working with aggregator transformation?
how to load rows into fact table in data warehouse
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What is dimensional table? Explain the different dimensions.
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What are the differences between joiner transformation and source qualifier transformation?
Briefly define reusable transformation?
What if the source is a flat-file?
How can we use mapping variables in informatica? Where do we use them?
According to his methodology what all you need before you build a datawarehouse
How can you define user defied event?
What are mapplets? How is it different from a Reusable Transformation?
What is the sequence generator transformation in informatica?
What are the different components of powercenter?
