What is partitioning? Explain about round-robin, hash partitioning.
Difference between flat files and relational sources?
what are the data modeling tools you have used?(polaris)
what is a worklet?
how do u decide whether u need to do aggregations at database level or at Informatica level?
What is partitioning? Explain different types of partitioning?
What are the types of Data Warehouse applications?
What is tracing level and what are the types?
what are variable ports and list two situations when they can be used?
how do u really know that paging to disk is happening while u are using a lookup transform?
what is dynamic insert?
Do we need an etl tool?
What is etl process. How many steps etl contains explain with example?