In abinitio, what types of parallelism are used?
What do you mean by a transaction file?
Explain the ab initio etl tool in high level?
What is the difference between look-up file and look-up, with a relevant example?
How would you find out whether a sql query is using the indices you expect?
Describe what the SQL Server tempdb and tlog files are used for?
Explain PDL with an example?
What do you mean by the term data warehousing?
What is the importance of eme in abinitio?
Input A 100 NUll A NUll 200 B 100 Null B Null 300 Output A 100 200 B 100 300 Do this using Ab initio
Describe in detail about lookup?
Suppose you find the term validation mentioned with a set of data, what does that simply represent?
Mention what is the syntax for m_dump in abinitio?
What do you understand by a cartesian join?
how to insert/update a csv file by comparing it with another csv file?