how we can update a target table without update strategy and
update override?
Answer Posted / bhupal
In session properties we can use update as update to update the target but target should contain the primary key in base table or in informatica level.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Informatica Checkpoints
how to create user defined function (udf) in informatica
What are the different lookup cache(s)?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What are the types of schemas we have in data warehouse and what are the difference between them?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Explain joiner transformation in informatica
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the types of lookup transformation?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
What is complex mapping?
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?
Enlist some properties of sessions.