Using aggrgator one way,Another way write query from database stage like

count number of deptno in a emp table?

Question Posted / naganji mandru

Answer Posted / naganji mandru

Using aggrgator one way,Another way write query from database stage like

Select deptno,count(*) as c from emp group by deptno

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the project in datastage?

1046

What is the difference between validated and compiled in the datastage?

1190

what is the use of skid in reporting?

2307

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

992

Triggers,VIEW,Procedures

1175

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1193

Is possible to create skid in dim,fact tables?

2587

Define APT_CONFIG in Datastage?

1019

What are the different layers in the information server architecture?

1076

If you want to use a same piece of code in different jobs, how will you achieve this?

1224

Define Data Stage?

1040

whom do you report?

1879

Differentiate between Join, Merge and Lookup stage?

1037

How we can covert server job to a parallel job?

1061

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

887