Describe in detail about lookup?
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.
What do you understand by overflow errors?
What do you mean by the overflow errors?
What do you mean by a transaction file and how it is different from that of a sort file?
how to insert/update a csv file by comparing it with another csv file?
What are the reasons for which business can trust the approach of data processing?
Describe how you would ensure that database object definitions (tables, indices, constraints, triggers, users, logins, connection options, and server options etc)are consistent and repeatable between multiple database instances (i.e.: A test and production copy of a database)?
Have you ever encountered an error called “depth not equal”?
What are the facts that can compromise data integrity?
How many components in your most complicated graph?
What are the differences between informatica and abinitio?
Have you used rollup component? Describe how.
How can a graph be run infinitely?
What are the different types of partition components in abinitio?