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

Answer Posted / sehaj

BY USING DYNAMIC LOOK UP CACHE!

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are pre and post-session shell commands?

744


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6417


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1136


What all join we can perform in LOOKUP transformation?

569


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1660






How to update source definition?

634


I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1089


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

611


can we override a native sql query within informatica? Where do we do it? How do we do it?

600


Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1539


what are the Methods For Creating Reusable Transformations?

649


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

1976


how to load dimension table and fact table. plz tell me the steps.

1687


What are active transformations.

1190


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

640