Suppose we are using a Dynamic Lookup in a Mapping and the commit
Interval set for the tgt is 10000. Then how does the data get
committed in the lookup if there were only 100 roows read from
the src and the dynamic lookup dint have the 100th row in it?
- 3 Answers
- 17129 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
Answer Posted / akash
The cache data should not get impacted in this scenario. The commit interval is a target property.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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?
What does update strategy mean, and what are the different option of it?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is main use of mapplet?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is dynamic cache?
What is meant by target load plan?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What are connected or unconnected transformations?
How to use pmcmd utility command?
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 do you load more than 1 max sal in each department through informatica or write sql query in oracle?
How union transformation is used?
What is a shortcut and copy in Informatica and how two are different with each other?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
