Static cache
|
Dynamic cache
|
You cannot insert or
update the cache.
|
you can insert rows into the cache as you pass to the target
|
The Informatica server returns a value from the lookup table or
cache when the condition is true. When the condition is not true, the
Informatica server returns the default value for connected transformations
and null for unconnected transformations.
|
The Informatica server inserts rows into cache when the
condition is false. This indicates that the row is not in the cache or target
table. You can pass these rows to the target table.
|
I have attended Informatica interview last week in wipro and couple of other companies, Question below I faced in those companies. 1. What are the main issues while working with flat files as source and as targets ? 2. Explain about Informatica server process that how it works relates to mapping variables? 3. write a query to retrieve the latest records from the table sorted by version(scd) 4. How do you handle two sessions in Informatica 5. which one is better performance wise joiner or look up 6. How to partition the Session? 7. How many types of sessions are there in informatica.please explain them. 8. Explain the pipeline partition with real time example? 9. Explain about cumulative Sum or moving sum? 10. CONVERT MULTIPLE ROWS TO SINGLE ROW (MULTIPLE COLUMNS) IN INFORMATICA 11. DEPLOYMENT GROUPS IN INFORMATICA 12. LOAD LAST N RECORDS OF FILE INTO TARGET TABLE - INFORMATICA 13. LOAD ALTERNATIVE RECORDS / ROWS INTO...
Comments
Post a Comment