select count (*), deptno from emp group by deptno having count(*)>10;

what r the propertes of workflow? and write quary to select
dept more ten employess in dept.?

Question Posted / srikanth

Answer Posted / srikanth

select count (*), deptno from emp group by deptno having
count(*)>10;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain lookup transformation is active in informatica

1150

What are the differences between oltp and olap?

1018

Explian the Process of deployment groups in informatica

1102

How to handle decimal places while importing a flatfile into informatica?

1242

Name at least 5 different types of transformations used in mapping design and state the use of each.?

1200

Explain about Informatica server process that how it works relates to mapping variables?

1128

What is a stored procedure transformation?

1113

What are some examples of informatica etl programs?

990

Explain the use of aggregator cache file?

1322

Define sessions in informatica etl?

1104

what is mean by complex business rule ?

2221

What are junk dimensions?

1117

How can you generate reports in informatica?

1083

Can we override a native sql query within informatica?

1092

Why update strategy and union transformations are active? Explain with examples.

1288