Informatica вопросы и ответы для интервью
Вопрос 36. Explain the concept of a Parameter File in Informatica.
A Parameter File in Informatica is a text file that contains parameter values used to replace placeholders in session and workflow properties at runtime.
Вопрос 37. What is the purpose of a Router transformation in Informatica?
A Router transformation in Informatica is used to filter data rows to different output groups based on specified conditions.
Вопрос 38. Explain the concept of a Sorter transformation.
A Sorter transformation in Informatica is used to sort data based on one or more columns before passing it to the target transformation.
Вопрос 39. What is a Lookup Override in Informatica?
A Lookup Override in Informatica allows you to override the default SQL query generated by the Lookup transformation to customize data retrieval.
Вопрос 40. Explain the concept of a Surrogate Key in Informatica.
A Surrogate Key in Informatica is a system-generated key used to uniquely identify rows in a dimension table, often replacing natural keys for efficiency.
Самое полезное по оценкам пользователей:
- What is Informatica PowerCenter?
- What is a Repository Service in Informatica?
- Explain the concept of a Source Filter in Informatica.
- What is a Lookup Override in Informatica?
- What is a Session in Informatica?