Suppose we assign you a new project. What would be your initial point and the key steps that you follow?
What is m_dump?
What do you understand by local lookup?
Difference between informatica vs ab initio?
What will be the output when a file with 0 records is connected as input to a reformat and an output file? Note that in reformat we have assigned hardcoded values to output columns.
How to run a graph infinitely?
What are the different types of partition components in abinitio?
What is the difference between dml expression and xfr expression?
What do you know about partition and also tell us about partition components in abinitio?
What are the functions of the replicate and dedup component?
Describe what the SQL Server tempdb and tlog files are used for?
What is a rollup component?
What are the Types of parallelism in detail?
Can sorting and storing be done through single software or you need different for these approaches?
What are the operations that support avoiding duplicate record?