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 the informatica workflow?

1036


can we override a native sql query within informatica? How do we do it?

1105


what is $$$$?

2130


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2377


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

1005


what is Active lock explain

2769


COM components can be used in Informatica

2366


What is sorter transformation?

1022


What is meant by lookup transformation? Explain the types of lookup transformation?

931


In development project what is the process to follow for an etl developer from day1

1698


What is expression transformation?

1083


What is native users?

1137


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7182


How do you use reject loader.

2583


Why filter transformation is an active one?

964