When do we use dynamic cache and static cache in connected
and unconnected lookup transformations?
Answer Posted / vinod saini
Dynamic cache uses for updation of Master Table & SCD type 1
Static uses for Flatfile
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
What is joiner transformation?
What are the popular informatica products?
What is mapping debugger?
How to do unit testing in informatica? How to load data in informatica ?
What are the components of Informatica? And what is the purpose of each?
How can we use batches?
Explain informatica architecture - version 8 / 9
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the reusable transformations?
Which are the different editions of informatica powercenter that are available?
What is the use of target designer?
What are data-driven sessions?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
How to update a particular record in target with out running whole workflow?