Answer Posted / saif
uncheck the caching option.
it will hit the database for each source record.
it will give good performance in case of incremental load
(which normally process less number of rec) but for full
load it may not.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are pre and post-session shell commands?
Performance tuning in UNIX for informatica mappings?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is meant by incremental aggregation?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
What is meant by query override?
What is dynamic cache?
Differentiate between a database and data warehouse?
What are the differences between source qualifier and joiner transformation?
Describe data concatenation?
What are the different types of repositories created using informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
How many ways are there to create ports?
What is workflow? What are the components of workflow manager?