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

How to load the data into target table, which not have
Primary/Surrogate key (Duplicate records not acceptable)

Answer Posted / upendra

sq--> srtr-->aggr-->tgt

note:
srtr->properties->
select distinct and connect to aggr tr
aggr-->group by key column
aggr->properties->select sorted input
and connect to tgt

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the performance considerations when working with aggregator transformation?

1209


During the running session, output files are created by informatica server. Enlist few of them.

1022


hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

2048


Explain the different lookup methods used in informatica?

1098


How might one distinguish in the case of mapping is right or not without associating session?

1197


Which development components of informatica have the highest usage?

1099


Parameter and variable differences

2110


What are the settings that you use to configure the joiner transformation?

1104


What is meant by target load plan?

1030


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

2445


COM components can be used in Informatica

2455


What is resilience time?

1227


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2404


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1847


Performance tuning in UNIX for informatica mappings?

2625