in my lookup table i want to catch the recently updated
records from the source to target,how to achieve this and what
is last commit interval point for this?
Answers were Sorted based on User's Feedback
What are junk dimensions?
What is the functionality of update strategy?
I have source like this 1:2;3. so i want to load the target as 123
have you developed documents in your project? and what documents we develop in realtime?
what is the main advantage of unconnected lookup
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
What is data merging,data cleansing,sampling?
What is ThroughPut in Informatica, How it works, Where I can find this option to check ?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
Draw a workflow diagram for this situation. If s3 is true session s4 and s5 should concurreently Run.if any one s4 or s5 true it should run s1.If s1 sucess it should execute s2 otherwise exit.can any one give me suggestion.Thanks in advance.
source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.
what is the diff b/w union and joiner and lookup?