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

What is the difference between Active and Passive transformation?

1224


Under which circumstances, informatica server creates reject files?

1142


what is $$$$?

2204


How many dimensions are there in informatica?

1135


Scheduling properties,whats the default (sequential)

2014


What is decode in static cache?

1264


What is an active transformation?

1159


Explain the pipeline partition with real time example?

1200


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

1693


can you please explain me pre session and post session options?

7678


How to configure mapping in informatica?

1225


Can we override a native sql query within informatica?

1092


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1957


Explian the Process of deployment groups in informatica

1102


Enterprise data warehouse your projects phase by phase explain?

1969