Can we insert and update a target table without using update
strategy transformation?How?
Answer Posted / rayudu
Yes By default if we wont use update stratagey t/r it will
insert the record by default .And if we want to update
without using update stratagey give the property UPDATE for
TreatSource rows at session level and in target properties
give updateas Update so that we can update without using UPD
T/r.
Regards,
rayudu.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
whats the logic to load the lower level of granularity of data to fact table.
Explain about Informatica server process that how it works relates to mapping variables?
Explain your project of banking domian.
explain one complex mapping with logic? sales project?
How to elaborate powercenter integration service?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What is meant by LDAP users?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What are the features of complex mapping?
Explain how many types of dimensions are available in informatica?
What is the need of etl tools?
what is $$$$?
How are indexes created after completing the load process?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
what is index?how it can work in informatica