What do you understand by the term ‘transformation’?

518

how do u estimate the depth of the session scheduling queue? Where do u set the number of maximum concurrent sessions that Informatica can run at a given time?

1545

What is partitioning? Explain different types of partitioning?

652

What is etl process?

530

what are Lookup caches options? Including persistent caches.

1435

Explain the key challenges that you face while performing etl testing.

563

How etl testing is different from database testing?

515

What are the different etl testing categories as per their function?

530

how many steps are there in etl process?

531

When do we analyze the tables? How do we do it?

520

what is the difference between cardinality and Nullability?

2504

how do u identify the changed records in operational data?

2131

how to do aggregation (year wise quantity ) using only source qualifier, the source is sql server date as datetime data type and target as flat file with year (string datatype)

2232

How to delete data which is not in source table?

828

What is the difference between round-robin partitioning and hash partitioning?

542