when do we use static cache and when do we use dynamic cache
in lookup transformation? with example.
Answer / swapna
static cache is used when the records in the source does not update more frequently.
dynamic cache is used when the records in the source frequently updates.
| Is This Answer Correct ? | 1 Yes | 0 No |
how to convert the .doc docs into .txt format using informatica
Explain how many types of dimensions are available in informatica?
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
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 can we join the tables if they don't have primary and foreign key relationship and no matching port?
In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
define galaxy repository in informatica
what is target load plan
In how many ways we can create ports?
I HAVE 10 records in source. I want to store i record in target 1, second record in target 2, third record in target 3, 4 th record again in target 11, 5th again in target 2, 6th again in target3 etc.... how it is possible?
how can we load 365 flat file to a single fact table (target) as a history load in single mapping?