Can we have a Mapping without a Source Qualifier?
- 14 Answers
- 45794 Views
- Deloitte, I also Faced
- E-Mail Answers
Answer Posted / nagesh
No. Sourse Qualifier is a must for informatica mappings.
What the source qualifier does is, when we add a relational
or flat file source definition to a mapping, we need to
connect it to a Source Qualifier Transformation. The SQ
represents the rows that the Integration Service reads when
it runs in the session.Because we need to apply a business
logic in the staging area, the SQ allows us to access the
data and convert it into the informatica data types thro
respective transformations. Thus we will be able to apply
the business logic and transform the data to be compatible
with target database with the help of SQ.
| Is This Answer Correct ? | 4 Yes | 7 No |
Post New Answer View All Answers
What is a dimensional model?
What are the different types of repositories created using informatica?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is the Process to creating lookup transformation in informatica
What could be the possible resons of locks by user?
Which means the first record should come as last record and last record should come as first record and load into the target file?
scenario where i can use only concurrent execution of workflow.
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is substr in informatica?
What is a repository manager?
What is meant by incremental aggregation?
What is target designer and target load order?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
What is xml source qualifier transformation in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
