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
- 17128 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
Can u generate reports in Informatica?
Define filter transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What are the reusable transformations?
can you please explain me pre session and post session options?
Tell me about Propagate functions in informatica
What is persistent lookup cache?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the different types of olap? Give an example?
What is depict expression change?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
I have a flat file, want to reverse the contents of the flat file
What is deployment group?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
what is size of u r database?
