how we can update a target table without update strategy and update override?

how we can update a target table without update strategy and
update override?

Question Posted / mehul.thakur

3 Answers
7474 Views
TCS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how we can update a target table without update strategy and update override?..

Answer / moorthy g

In Session Properties
Treat source row as: update
This way you can update in the target
Best Regards
Moorthy. G

Is This Answer Correct ?

7 Yes

2 No

how we can update a target table without update strategy and update override?..

Answer / 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

how we can update a target table without update strategy and update override?..

Answer / sehaj

BY USING DYNAMIC LOOK UP CACHE!

Is This Answer Correct ?

0 Yes

4 No

Post New Answer

More Informatica Interview Questions

what is the difference between stop and abort?

3 Answers TCS,

What is data transformation manager process?

0 Answers

what is the mechanism of the Master-Detail joining condition?

6 Answers IBM, Patni,

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers

Explain dynamic target flat file name generation in informatica

0 Answers Informatica,

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

0 Answers

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

0 Answers

When the informatica server marks that a batch is failed?

2 Answers

How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers TetraSoft,

What are the types of lookup?

3 Answers Wipro,

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers Zensar,

For more Informatica Interview Questions Click Here