When do we use dynamic cache and static cache in connected and unconnected lookup transformations? Difference between stop and abort


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More ETL Interview Questions

what happens if the info.server doesn't find the session parameter in the parameter file?

2 Answers  


what is the meant by Normalization and de-normalization?

2 Answers  


Identifying the bottlenecks in various components of Informatica and resolving them.

0 Answers  


Explain the difference between etl tool and olap tools?

0 Answers  


What is the difference between project backlog and product backlog?

0 Answers   IBM,


How to recover a workflow? What are the different approaches?( In prod i.e no access to modify)

0 Answers   IBM, Saama Tech, Wipro,


In informatica, I have 10 records in my source system. I need to load 2 records to target for each run. How do I do this?

0 Answers  


how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.

2 Answers   CTS,


without using ETL tool can u prepare a Data warehousing and maintaining?

3 Answers  


what is the difference steps for data modeling?

0 Answers  


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)

0 Answers   Thomson,


Hi, can anyone plz share the project architecture for etl testing(banking domain) plz explain the architecture .

0 Answers   Cap Gemini,


Categories