Interested to Buy Any Domain ? << Click Here >> for more details...
Can we have a Mapping without a Source Qualifier?
- 14 Answers
- 50290 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
Explain the informatica workflow?
Define mapping and session?
What are the limitations of joiner transformation?
What is a surrogate key?
What is persistent lookup cache?
what is the -ve test case in your project.
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?
Is there any way to read the ms excel datas directly into informatica?
what is informatica metadata?
What is informatica? Why do we need it?
What are the components of Informatica? And what is the purpose of each?
1. When u r checking out what ll happens for version no? a. Increase b. decrease c.reset to 0 d. reset to 1 e. no change 2. Salary of all employees needed to add with the commision. What transfrmation to be used? a. SQ and Expression b. SQ c. Update Strategy d. Expression 3. Which of the task is used to run a session based on success of the other session? a. Decision b. Event wait c. Email d. Command e. None 4. Types of sources in Informatica? a. Homogenous n Heterogenous b. None c. Cobol n XML d. Flat files e. Flat files and Homogenous n Heterogenous 5. Servers are available in informatica? a. Informatica Server and Workflow server b. Informatica Server and Informatica Repository Server c. Informatica Server d. Workflow server e. Informatica Repository Server 6. While using Pmcmd in cmd line mode, each command must include the connection info of which of the following? a. workflow manager b. Power Center server c. Workflow monitor d. Repository manager e. Designer 7. Workflow montior displays workflows that have run a. once b. twice c. never d.four times e. thrice 8. Mode for handling sessions n workflows? a. server mode b. Wait mode c. Command line mode d. User mode e. Interactive mode 9. Connection details configured in? a. Mapping designer b. Workflow manager c. Workflow monitor d. Repository manager e. Worklet designer Thanks in Advance
wat are deployement groups in informatica, how it will be used for developers
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain constraint based loading in informatica
