how would u estimate the size of Lookup transform data and
index cache?
Answer Posted / san
Just run the session once, and check for the session logs
you will get the DATA and IDX cache size.
Regards,
San
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are snapshots?
Is hadoop a etl tool?
Explain etl mapping sheets?
how do use session mapping parameters ?(in which transformation)
What is fact? What are the types of facts?
What is cube grouping?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is the difference steps for data modeling?
when u connect the repository for the first time it asks you for user name & password of repository and database both.But subsequent times it asks only repository password. why?
How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)
What is a mapping, session, worklet, workflow, mapplet?
Can we create Hierarchies in generic datasources?
Identifying the bottlenecks in various components of Informatica and resolving them.
how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)
Explain about etl data integration software?