two tables from two different databases r there . both
having same structure but different data . how to compare
these two tables ?
- 10 Answers
- 23554 Views
- HP, Patni, I also Faced
- E-Mail Answers
Answer Posted / sowjanya
If the tables are from two different databases you should
use JOINER to join them.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
What is sorter transformation?
What is joiner transformation?
How to create Target definition for flat files?
Enlist some properties of sessions.
How to elaborate powercenter integration service?
What is a difference between complete, stop and abort?
Explain informatica architecture - version 8 / 9
What are active and passive transformations?
How to load the data from people soft hrm to people soft erm using informatica?
What is a connected transformation?
Define filter transformation?
Explain about cumulative Sum or moving sum?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain the use of aggregator cache file?
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
