When do we use dynamic cache and static cache in connected and unconnected looku

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

Question Posted / nikhil arya

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

More ETL Interview Questions

what is the difference steps for data modeling?

What are cubes and olap cubes?

What is ROWID explain ?

what are the different Reporting and ETL tools available in the market?

what is dynamic insert?

What is the main difference between peek stage and copy stage

when will use SQL override in a lookup transformation?

What is tracing level and what are the types?

What are your responsibilities as an etl tester?

what is the difference between OLTP database and data warehousing database?

what is session partitioning?

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

For more ETL Interview Questions Click Here