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
7377 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

i want to convert below src into target src is as follows maths 30 science 20 social 81 i want data in trg like below maths science social 30 20 81

2 Answers HCL, HP,

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers IBM,

what is lookupoverriding?

1 Answers

How do you change a non-reusable transformation to reusable transformation?

0 Answers

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers TCS,

Explain about HLD and LLD ?

16 Answers Accenture,

how to convert the .doc docs into .txt format using informatica

4 Answers

What are the main features of Oracle 8i with context to datawarehouse?

0 Answers

I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?

2 Answers

The Source coloumns are A,B,C with data row1- 10,20,30 row2- 40,50,60 row3-70,80,90 and so on. In the target I want one coloumn with the following data, Coloumn-X, row1-10,row2- 20,row3-30,row4-40,row5-50 and so on. How to achieve this?

3 Answers Cap Gemini,

what type of problem you faced insales project or insurance project

1 Answers Sony,

In informatics server which files are created during the session rums?

0 Answers

For more Informatica Interview Questions Click Here