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

Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?

2 Answers  

In any project how many mappings they will use(minimum)?

1 Answers  

Hi I have two sources like A, B. My source A contain 10000 million records from that i need 20 attributes. My source B has also same 10000 million records from that i need only 1 attribute. By using Joiner i have to load into target? Is there any issue regarding this? if issue is there how to tune this mapping in best way?

2 Answers   Zensar,

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

expain about the tune parameters?

0 Answers   TCS,

Why you use repository connectivity?

3 Answers   Yash Technologies,

What is mapping debugger?

0 Answers  

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

explain different types of modeling.

2 Answers  

What will happen when Mapping variable and Mapping parameter is not defined or given? Where do you use mapping variable and mapping parameter?

10 Answers   Deloitte,

why sequence generator should not directly connected to joiner transformation ?

1 Answers   ANZ,

What is the function of aggregator transformation?

0 Answers