Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

suppose if we have dublicate records in a table temp n now
i want to pass unique values to t1 n dublicat values to t2
in single mapping using aggregator & router? how

Answer Posted / srinu

I have a idea after sql transformation go thruogh 2 Agg
Trans,2 Router Trans
Agg1-gorup by col count=1 to router trans
Agg2-group by col count<>1 to router trans

I am not confident check itonce let me know,,

Thanks
Srinu

Is This Answer Correct ?    5 Yes 17 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain lookup transformation in informatica

1080


What is meant by target load plan?

975


What does role playing dimension mean?

1048


Which is the t/r that builts only single cache memory?

1190


Enlist few areas or real-time situations where informatica is required.

1089


What is event and what are the tasks related to it?

1122


What do you understand by term role-playing dimension?

1049


What are the new features of informatica 9.x at the developer level?

1044


Explain sessions. Explain how batches are used to combine executions?

1034


What is different between the data warehouse and data mart?

1070


Slowly changing dimensions, types and where will you use them

1717


Whats the difference between informatica powercenter server, repositoryserver and repository?

1178


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1905


Explain the informatica workflow?

1074


What you know about transaction control transformation?

996