How to Answer: Can you explain the differences between a connected and an unconnected lookup and when you should use each of them in a data migration?
Advice and answer examples written specifically for a Data Migration job interview.
2. Can you explain the differences between a connected and an unconnected lookup and when you should use each of them in a data migration?
How to Answer
This question asks you to compare two similar but different terms and to discuss when to use them in data migration. This is a typical operational question which starts with a definition and then asks you to describe how you would apply it. As a seasoned data migration operator, you should be able to answer this question easily.
Written by William Swansen on March 17th, 2020
Answer Example
"The two types of lookups are called connected and disconnected. A connected looked up is used for mapping and will return multiple values. It is called connected because it can be tied to another transformation. On the other hand, and unconnected lookup is used when it cannot be connected to another transformation. It returns a single value, but it is reusable."
Written by William Swansen on March 17th, 2020
Experienced
"Connected and unconnected lookups or similar but slightly different. They both query the tables and provide values as a result of the operation. The difference is that connected lookups are part of the workflow and can be tied to another transformation. Unconnected lookups only provide a single output and cannot be connected to other operations. Both types of lockups can be reused if necessary."
Written by William Swansen