Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - Why we are using aggregator with out using group by?




571
views
asked marvit September 20, 2014 08:04 AM  

Why we are using aggregator with out using group by?


           

1 Answers



 
answered By vishnoiprem   0  
1) Using the sql override in the source qualifier. To find the even and odd. Add another column to flag the even and
odd.Like

select ID,decode( id/2,0,'E','O') FLAG FROM TABLE_NAME;

Using the router we can send them into two separate target
tables.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert