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 do you mean by worklet?
what is the Default Source Option For Update Strategy Transformation?
how will you get 21 to 30 record from 50 records?
Where is the cache stored in informatica?
During the running session, output files are created by informatica server. Enlist few of them.
tell me some dimension tables names in banking domain informatica project(dont tell like depends on project, tell me names of dimension and fact table names in your project)?
What are the advantages of informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
we have to use order by,where,having we to implement sql query
If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.
What is staging area?