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?
- 2 Answers
- 14396 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
Answer Posted / abhishek singh
First of all can u please tell me whether target is used as
source in this mapping.
If target is used as source in the mapping then commit
interval should be 1.
In other case where target is not used as source then it
could be anything, In your case it will be 10000.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Explain the tuning lookup transformation - informatica
How can we create index after completion of load process?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
How can we use mapping variables in informatica? Where do we use them?
How can we use batches?
Why filter transformation is an active one?
scenario where i can use only concurrent execution of workflow.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain why we use partitioning the session in informatica?
What are the different clients of powercenter?
How big was your fact table
What is a snowflake schema?
What are the differences between a connected lookup and unconnected lookup?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Scheduling properties,whats the default (sequential)
