Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have a Mapping without a Source Qualifier?
- 14 Answers
- 50278 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 i havee 3records in my source having same deptno like Deptid Deptno ------ ------ 101 10 201 10 301 10 and i am using router TR to loading these records into target.Then how many record'll be loaded into target???
What is workflow? What are the components of the workflow manager?
how will compare two mappings in two different repository?
What is a snowflake schema?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What are the steps involved in the migration from older version to newer version of Informatica Server?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are data-driven sessions?
what is mean by complex business rule ?
What is the Difference between SetVariable and setmaxvariable in informatica?
Teradata 
