Interested to Buy Any Domain ? << Click Here >> for more details...
How to compare Source and Target table, without using
dynamic lookup?
- 4 Answers
- 10868 Views
- I also Faced
- E-Mail Answers
Answer Posted / nagaraju bhatraju
YOu can join the Source and target columns at the source
qualifer level,if you have public synonym on the target, so
that the table can be accessed from all the schemas.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How can we store previous session logs?
What is a passive transformation?
What is the fact table?
How many input parameters can exist in an unconnected lookup?
What are the steps involved in the migration from older version to newer version of Informatica Server?
What is repository manager?
Explain the different kinds of facts.
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Enlist the differences between database and data warehouse.
What does “tail –f” command do and what is its use as an Informatica admin.
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
What is deployment group?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Mention few power centre client applications with their basic purpose?
What is data transformation manager process?
