Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 17905 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
Answer Posted / imran
The dynamic lookup cache will be updated in real-time as each row is processed, independent of the target commit interval. The target commit interval only affects when the data is committed to the target table, not when the dynamic lookup cache is updated. Thus, the dynamic lookup will contain the 100th row immediately after it is processed, even though the target table commit interval is not reached.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the size of u r source(like file or table)?
What is the Rank index port in Rank transformation?
What is lookup transformation?
How many ways are there to do 'remove duplicate records in informatica'?
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is the hint? how to use it to reduce the query processing in program?
Can we override a native sql query within informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is the procedure for creating independent data marts from informatica 7.1?
Informatica settings are available in which file?
What is sequence generator transformation in informatica?
Explain load alternative records / rows into multiple targets - informatica
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
