If i have one source having 10 ports.In a mapping i use that
source one target having that ten ports.Data from 5 ports
are going to target through a mapplet and another 5 ports
are going to target through another mapplet.Both 2 mapplets
are intially passive in nature.But presently my requirment
to convert on mapplet to ACtive.How can i do it.
Answer Posted / mohan
add active transformation to mapplet or if mapplet has
already an active/passive transformation then we can add
some filters/confitions to it then mapplet becomes an
active mapplet
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
how to create user defined function (udf) in informatica
What are roles and groups and benefits of using them?
Describe an informatica powercenter?
What is exclusive and normal mode for repository services?
How do you load first and last records into target table?
What is the sql query overwrite in source qualifier in informatica
How do you handle two sessions in Informatica
can we override a native sql query within informatica? Where do we do it?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Quickly characterize reusable change?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
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
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What could be the possible resons of locks by user?