How will you update the row without using update statergy?
Answer Posted / prasad
In target
there is a update override option is there using this one we
can update the records without using update strategy t/r
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
tell me about your project functionality
How can we create index after completion of load process?
Explain the different kinds of facts.
What is the scenario which compels informatica server to reject files?
What is enterprise data warehousing?
Performance tuning( what you did in performance tuning)
Briefly describe lookup transformation?
Explain direct and indirect flat file loading (source file type) - informatica
whats the logic to load the lower level of granularity of data to fact table.
How do you remove duplicate records in informatica? And how many ways are there to do it?
Is it possible to revert a global repository to local one and why?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
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.
How do you set a varible in incremental aggregation
What does role playing dimension mean?