Interested to Buy Any Domain ? << Click Here >> for more details...
what is dynamic cashe
- 3 Answers
- 6893 Views
- Informatica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / priyaraj
The dynamic cache represents the data in the target.The
integration service uses the data in the associated port to
insert or update rows in the lookup cache.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rajan raorane
1) It is used to insert the data in Cache and Target
2)Informatica dynamically inserts the Data in target
3) Data is inserted only when the condition is false i.e It
means no data is available in target and cache table
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / harish konda
The Dynamic Lookup Cache is used to update/insert the data
into the cache.
When the session starts, if dynamic cache is used, it
fetches all the target data into its cache. And during the
session IS scans the whole dynamic cache acc. to the lookup
condition we give. It updates/inserts the cache accordingly
if the row exists/new row respectively.
When dynamic cache is selected one column named
"NewLooupRow" gets added into the lookup t/f. When a row
coming from source is new then returns 1 that is insert,
when a row coming as update then its returns 2 that is
update, and when a row coming with no changes as it is in
target before then 0 is returned.
So we can use these NewLooupRow values in other t/f's
accordingly and give conditions to update/insert/reject.
So indirectly target table gets updated/inserted/deleted
according to these values of NewLooupRow only.
| Is This Answer Correct ? | 0 Yes | 0 No |
Tell me about MD5 functions in informatica
can u give example for factless fact table
How can you define user defied event?
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
Mention a few design and development best practices for informatica?
How to extract sap data using informatica? What is abap? What are idocs?
What is a candidate key?
What is workflow? What are the components of workflow manager?
explain abt ur project architecture?
0 Answers Anthem, DELL, IBM, TCS, Wipro,
what are the types of Data warehousing ?
tell me 7.x and 8.x diferrencess(but not transformations)
What is a stored procedure transformation?
Teradata 
