Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have a Mapping without a Source Qualifier?
- 14 Answers
- 49295 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 |
Hi, I am working on informatia in a support role. We used stored procedures in informatica and other than that I never got a chance to work on PL/SQL,little on Unix scripts. But I heard people asking about PL/SQL alot. Can any one let me know how do we use PL/SQL with informatica and if required what is the knowledge that we need to have on PL/SQL? Please let me know in detail which would really help me alot in my career prospectus.
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
what is unique constraint error ?
If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.
What are the challenges you have faced in your project?
what is the drillup & drill down?and use of the drill up and drill down?
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What are events in workflow manager?
How to implement security measures using repository manager?
What are the tuning techniques you applied during your last project
What are data-driven sessions?
Teradata 
