nice video! one suggestion- you could have use directly a expression followed by update strategy and in the update strategy a condition can be mentioned as IIF(NewLookupRow=1,dd_insert,iif(NewLookupRow=2,dd_update)). This way there was no need to use a router and to use the same target twice in the same map.
+ankit nighojkar Hi Ankit cud u tell me if i need to do anything in the exp transformation. I am not able to update the target even though i have put the condition IIF(NewLookupRow=1,dd_insert,iif(NewLookupRow=2,dd_update)) in the update strategy expression. The error that I get is that unique constraint violated. Any help would be very much appreciated.
.... Can u please explain what is testing and what is difference between automation and manual testing..... Is informatica comes under etl tool...... Is all tools have automation and manual testing
I have a doubt here.. In dynamic lkp, it will check existence of same valued columns. If not present it will create based on newlookuprow. If it is present, then why to update again in target table? Can u plz comment here?
1 doubt . If the cache is not persistent . Whats the use if cache is being updated within execution or after execution . As cache will be deleted after session is run right ?
if we get same deptno with different loc how to update and insert like deptno 10 chennai deptno 10 mumbai 2 records should be in tgt with end date as sysdate and end date as high date for active record
hi i m new bee to informatica i worked out ur this video i m trying to update one reows inmy source table in workflow monitor the updated rows are reflect in applied rows but not in affected rows .how can i fix this.please help me
Tq for the video
This is the best video tutorial I have come across so far for dynamic lookup cache explanation.
wow..very nice video, you have explained so simply that now i find lookups easy to work.
nice video! one suggestion- you could have use directly a expression followed by update strategy and in the update strategy a condition can be mentioned as IIF(NewLookupRow=1,dd_insert,iif(NewLookupRow=2,dd_update)).
This way there was no need to use a router and to use the same target twice in the same map.
+ankit nighojkar Hi Ankit cud u tell me if i need to do anything in the exp transformation. I am not able to update the target even though i have put the condition IIF(NewLookupRow=1,dd_insert,iif(NewLookupRow=2,dd_update)) in the update strategy expression. The error that I get is that unique constraint violated. Any help would be very much appreciated.
Hi Zubair,
Go to Session --> Properties --> Treat Source Row as --> make it as (Data Driven).
By doing this you will not get any error.
:) :)
.... Can u please explain what is testing and what is difference between automation and manual testing..... Is informatica comes under etl tool...... Is all tools have automation and manual testing
I have a doubt here.. In dynamic lkp, it will check existence of same valued columns. If not present it will create based on newlookuprow. If it is present, then why to update again in target table? Can u plz comment here?
simple and good explanation... finally i understand the lookup caches concept after watching this vid..
hi through your videos i learnt what is informatica
Colud you please explane what is the use of "New Lookup Row"?
1 doubt . If the cache is not persistent . Whats the use if cache is being updated within execution or after execution . As cache will be deleted after session is run right ?
if we get same deptno with different loc how to update and insert like deptno 10 chennai deptno 10 mumbai 2 records should be in tgt with end date as sysdate and end date as high date for active record
Thanks for the clear explanation.
Static cache will not get updated after execution, it will get updated during the beginning of next session run.
hi
i m new bee to informatica i worked out ur this video i m trying to update one reows inmy source table in workflow monitor the updated rows are reflect in applied rows but not in affected rows .how can i fix this.please help me
Can u please send the static cache video link mam
I didnt see you put a condition for the lookup?
It is not transmission, it is transformation.
SCD 1
this is scd1 right?