with out using update strategy transnsformation how to
update the data in mapping level

Answer Posted / guest

By using target update override and by using sessions
property treat source rows as update.by using this options
we can update the data
If any statement is wrong try to correct it

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention a few design and development best practices for informatica?

563


Write the advantages of partitioning a session?

752


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 ?

1748


What are the different types of olap? Give an example?

564


What is update strategy transform?

580






How to create the source and target database connections in server manager?

634


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

1861


Define mapping and session?

587


What are the differences between source qualifier and joiner transformation?

602


Can we create a Integration service without a Repository service and vice versa?

730


How can we use mapping variables in informatica? Where do we use them?

621


Explain what are the different versions of informatica?

658


How to create or import flat file definition in to the warehouse designer?

618


Why is sorter an active transformation?

667


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1417