Interested to Buy Any Domain ? << Click Here >> for more details...
what is the diff b/w cached and unchaed look ups
- 3 Answers
- 7700 Views
- IBM, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / sunil
when lookup cahing is unabled, informatica server queries
the lookup table once,caches the lookup values during
session.This can inprove session performance.
when u disable lookup caching,each time row pass to the
transformation,informatica server issues an select
statement to lookup table for lookup values
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What are active and passive transformations?
Clarify the aggregator change?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How is union transformation utilized?
How are the sources and targets definitions imported in informatica designer?
What do mean by local and global repository?
Explain the pipeline partition with real time example?
What is the status code in stored procedure transformation?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to open an older version of an object in the workspace?
What is the procedure for creating independent data marts from informatica 7.1?
define galaxy repository in informatica
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
