Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have a Mapping without a Source Qualifier?
- 14 Answers
- 49276 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 fact table? Explain the different kinds of facts.
Define mapping and session?
How many input parameters can exist in an unconnected lookup?
Explain pushdown optimization and types in informatica
Name the different lookup cache(s)?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
Explain about cumulative Sum or moving sum?
What is a code page?
Explain the difference between a data warehouse and a data mart?
What is depict expression change?
can u give example for factless fact table
Partition, what happens if the specified key range is shorter and longer
How to elaborate tracing level?
What is the Rank index port in Rank transformation?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
