What happens if we dont select data driven option?
Answers were Sorted based on User's Feedback
Answer / vidyaveda4
if we dos't select the data driven option. at the time of running of the session it just simply ignores the options set in the update strategy transformation.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / gm
Suppose you are using onely one action like
insert or update or delete
then you can use session proerties.
If you are using more than one action. but you are not
selected data driven. The IS services Ignore the update
Strategy Transformation.
Note: Default is "insert option"
but if your are using more than 2 option then default data
driven.
===========================================================
Is This Answer Correct ? | 2 Yes | 0 No |
My i/p is like below 1,2,3,4,5,6,7,8,9,10....100 I want that to be populated in two o/p as below o/p-1: 10,20,30,40,50,60,70,90... o/p-2: 11,21,31,41,51,61,71,81,91.... How to do it in ingotmatica...
How to delete duplicate row using informatica?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
What is meant by query override?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to start a workflow using pmcmd command?
how the server recognises , if the session fails after loading the 100 records in to the target
What is a repository? And how to add it in an informatica client?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is informatica powercenter repository?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
How You Pull the records on daily basis into your ETL Server.