Answer / rama

select (distinct max(sal)) from emp

Answer / sudheer113

MAX(SAL) will not give duplicate records in a single group

Answer / anil kumar

select distinct max(sal) from table name

Answer / deva

select (distinct max(sal)) from emp
group by sal.

When ever you use goupfunctions in select statement grup by clause is must.....other wise it will throw an error

Answer / asdfg

select (distinct max(sal)) from emp
group by sal.

When ever you use goupfunctions in select statement grup by
clause is must.....other wise it will throw an error

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,

how many session run unix environment what command using ?

1 Answers   HCL,

What do you understand by SOA of Informatica?

0 Answers  

What is informatica? What exactly are the practical uses in real world

2 Answers  

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

0 Answers   CTS,

How to start a workflow using pmcmd command?

0 Answers  

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

how many data models u have done in informatica project?

2 Answers   TCS,

What is up date strategy and what are the options for update strategy?

2 Answers  

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

What is synonym?

2 Answers   Patni,