SRC1 -> EXP -> AGGR ->
TGT
SRC2 -> EXP ->
Above is a maaping with two pipeline connected to the taret
TGT. Design wise is this design is correct or not ?
Answer Posted / sarthak
If the column structure of the two pipelines are same...we
can use UNION t/f to pass data to single TGT instance
or
if we ll take 2 instances of TGT table.... then It ll be
correct...
else we can't connect two pipelines to single TGT instance
directly
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is target designer and target load order?
How can you validate all mappings in the repository simultaneously?
Define mapping and session?
draw informatica architecture 8.6 ?
Did u used latest transformations of 8.6.0? for what?
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
Define mapplet?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is an Integration service in Informatica?
Explain pushdown optimization and types in informatica
what is unit testing?tell me proceedure
What is the reusable transformation?
How to use pmcmd utility command?
What is the difference between stop and abort in informatica
What are the different clients of powercenter?