Answer Posted / rohit
I have below records.
EMPID,Name
101,car
101,car
102,Bus
103,Flight
103,Flight
103,Flight
103,Flight
104,Ship
output:-
101,car
101,car
#----------#
102,Bus
#----------#
103,Flight
103,Flight
103,Flight
103,Flight
#----------#
104,Ship
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Separate from a database, an information bazaar, and an information stockroom?
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 are the various types of transformation?
How many ways are there to create ports?
How to improve the performance of a session using sorter transformation?
Differentiate between a database and data warehouse?
Mention few advantages of router transformation over filter transformation.
Enlist some properties of sessions.
What differs when we choose the sorted input for aggregator transformation?
Explain the aggregator transformation?
What are the settings that you use to configure the joiner transformation?
What is union transformation?
Where can we find the throughput option in informatica?
How to generate sequence numbers?
can you please explain me pre session and post session options?
