Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have a Mapping without a Source Qualifier?
- 14 Answers
- 49918 Views
- Deloitte, I also Faced
- E-Mail Answers
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 |
if we hav 10 records in a file, can we get first record from it by using Aggregator with out using Groupby Port in it?If Yes..let me know the answer plz!!!
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
why do we go for update strategy tr in SCD rather using the session properties?
how lookup is acting as both active and passive ? how is it possitble?
Different types of Power center errors?
what is the location of parameter file in informatica?
what is the use of Java Transformation in Informatica 8.x?
in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?
What are connected or unconnected transformations?
If there are more than one sessions running parallel in a worklet, which will be the last session ?
What did you do in source pre load stored procedure
replace multiple spaces with single space.
Teradata 
