DSXchange

pls post sql queries for following stages

1>FUNNEL

2>AGGREGATOR

3>MERGE

4>PIVOT

Sorry, but that's all that came to mind when I saw your post. Perhaps someone else has something more constructive, but I honestly have no idea what you are trying to find out here.

There are no 'sql queries' in those stages - sql queries would only be appropriate for database stages and even there you'd need to be more specific.

chulett wrote:

Code: Select all

select 'What do you mean?' from dual where stage_name in ('FUNNEL','AGGREGATOR','MERGE','PIVOT')

Sorry, but that's all that came to mind when I saw your post. Perhaps someone else has something more constructive, but I honestly have no idea what you are trying to find out here.

There are no 'sql queries' in those stages - sql queries would only be appropriate for database stages and even there you'd need to be more specific.

every stage performs an operation to pick data and give the output, this is done automatically in datastage, alternatively there will be some sql queries to do the task similar to performed by the various stages, i wanted those queries, hope u are clear now!!!

abhay10 wrote:

chulett wrote:

Code: Select all

select 'What do you mean?' from dual where stage_name in ('FUNNEL','AGGREGATOR','MERGE','PIVOT')

Sorry, but that's all that came to mind when I saw your post. Perhaps someone else has something more constructive, but I honestly have no idea what you are trying to find out here.

There are no 'sql queries' in those stages - sql queries would only be appropriate for database stages and even there you'd need to be more specific.

every stage performs an operation to pick data and give the output, this is done automatically in datastage, alternatively there will be some sql queries to do the task similar to performed by the various stages, i wanted those queries, hope u are clear now!!!

Funnel - UNION
AGGREGATOR - Multiple-Row functions (Grouping Functions)
Merge - INNER JOIN, LEFT OUTER JOIN

If you read the manual and have some SQL background i'm sure you could have figured that out.
Hope this helps!