Few Questions

[myrcmstr]

1. What is the difference between Bulk/Normal/Insert mode?
2. How dynamic Sql is used in Informatica?
3. How cache is refreshed in Informatica?
4. What is reusable session in the workflow? What is it used for?
5. What is persistent cache in lookup ?
6. What is dynamic cache work in lookup ?
7. How slowly changing dimensions handled in Informatica?

 

[blom0344]

Each and every one of your questions (except the one on dynamic SQL) can be found in the standard documentation.
The topic of slowly changing dimension alone is covered in umpteenth pages.
Is this one of those 'silly' exam preparations?

Ties Blom

 

[ArtieChoke]

Right on, Ties! It sure sounds like it. If you own the product, use the help before posting questions that are easily answered there. The help is fairly detailed... except when it's not - which does happen - doh!

"I think we're all Bozos on this bus!" - Firesign Theatre