Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have a Mapping without a Source Qualifier?
- 14 Answers
- 49319 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 the benefit of partitioning a session?
What are the different types of transformation available in informatica.
Define the various join types of joiner transformation?
What is a mapplet/worklet in informatica?
In how many ways we can create ports?
What do you understand by term role-playing dimension?
Which transformation is needed while using the Cobol sources as source definitions?
What are the performance considerations when working with aggregator transformation?
Define pmcmd command?
How to elaborate tracing level?
What is informatica powercenter repository?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What happens when a session fails and you click on recover?
Explain the use of aggregator cache file?
