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...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How we can get unique records into one target table and
duplicate records into another target table??

Question Posted / manu

Answers were Sorted based on User's Feedback



How we can get unique records into one target table and duplicate records into another target table..

Answer / durgaprasad

data flow for this one is:

sq-->Aggregater-->Router-->target

in aggregater t/r take 2 output ports and give condition like

uniqe_port---->count(*)=1

duplicate_port--->count(*)>1

connect this one router and in router take 2 groups and
give condition like

uniqgroup=uniqe_port

duplicategroup=duplicate_port


and connect that groups to target

Is This Answer Correct ?    15 Yes 28 No

Post New Answer

More Informatica Interview Questions

What are the types of maping wizards that r to be provided in Informatica?

2 Answers  

what is diff between grep and find

3 Answers   IBM, iFlex,

WAT IS TEXT LOAD?

3 Answers   Wipro,

What is galaxy shema

2 Answers   CGI,

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

How are the sources and targets definitions imported in informatica designer?

0 Answers   Informatica,

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  

What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,

Differentiate between a repository server and a powerhouse?

0 Answers  

Define informatica repository?

2 Answers   Wipro,

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories