Explain complex mapping and write its features.

1.	Explain complex mapping and write its features.
Answer» When a mapping contains a LOT of requirements, which are BASED on too many dependencies, it is considered complex. Even with just a few transformations, a mapping can be complex; it doesn't NEED HUNDREDS of transformations. When the requirement has a lot of business requirements and constraints, mapping becomes complex. Complex mapping also encompasses slowly CHANGING dimensions. Complex mapping consists of the following three features. Large and complex requirements Complex business logic Several transformations

Answer»

When a mapping contains a LOT of requirements, which are BASED on too many dependencies, it is considered complex. Even with just a few transformations, a mapping can be complex; it doesn't NEED HUNDREDS of transformations. When the requirement has a lot of business requirements and constraints, mapping becomes complex. Complex mapping also encompasses slowly CHANGING dimensions. Complex mapping consists of the following three features.

Large and complex requirements
Complex business logic
Several transformations

Discussion

No Comment Found

Related InterviewSolutions

Explain the dimension.
What do you mean by the star schema?
What is the importance of partitioning a session?
Explain complex mapping and write its features.
What do you mean by incremental loading in Informatica?
What are different types of tasks in informatica?
Describe workflow and write the components of a workflow manager.
Explain what is DTM (Data transformation manager) Process.
Write difference between stop and abort options in workflow monitor.
What is the difference between SQL Override and Lookup Override?

Explain complex mapping and write its features.

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment