Can we have a Mapping without a Source Qualifier?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / santosh
NO.There is no question of mapping with out a source qualifier in informtica.
| Is This Answer Correct ? | 2 Yes | 5 No |
Answer / dj
I think yes we take source based lookup.plz correct if i was wrong
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / schwab
Actually NO,
But we can do that with the use of Maplet and maplet should
have SQ
| Is This Answer Correct ? | 2 Yes | 8 No |
What is polling?
What are the differences between oltp and olap?
What is the use of code page?
What is the difference between lookup override and souce qualifier override ?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
I have source like this 1:2;3. so i want to load the target as 123
What the difference is between a database, a data warehouse and a data mart?
what is Partitioning ? where we can use Partition?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.
in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?
What are the methods for creating reusable transforamtions?
wt is informatica file watch timers in aflat i want to get the first record and last record how could i.