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
- 17899 Views
- Deloitte, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / 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 |
Design a mapping to get year of join for each employee.
What is rank transformation in informatica
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
Difference Between ETL & ELT?
What is Datadriven?
my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times
Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.
how you will maintain version?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
what is the size ur source like(file system or database)? how many record daily come u r banking project?
0 Answers Cognizant, Flextronics,
Teradata 
