1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / mehul.thakur

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

If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?

2 Answers   IBM, WalMart,

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

3 Answers  

The question was on time stamp. what is the difference between HH and HH24 when to use when.

0 Answers   Nationwide,

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

what are challenges that you faced in testing? give solution to it?

1 Answers  




From where you extract the data, how you did it into informatica? explain....

1 Answers   Accenture, Unisoft Infotech,

what is workflow varible

1 Answers   HP,

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

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 will be the approach?

0 Answers  

followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200

2 Answers   Oracle,

what is diffrence b/w joner and union transfermation

6 Answers  

For more Informatica Interview Questions Click Here
Categories