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

Explain the different lookup methods used in informatica?

1035


Is it possible to create multiple domains on a single Informatica server?

1230


How to open an older version of an object in the workspace?

1196


Explain the different dimensions.

954


what is the size of your data warehousing?

2091


difference between repository database and repository service?

1141


What all join we can perform in LOOKUP transformation?

966


i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2114


What are the modules in Power Center

1674


Briefly define a session task?

1120


Explain in detail scd type 2 through mapping.

1034


How many ways a relational source definition can be updated and what are they?

1010


What are multi-group transformations?

1081


what is diff b/t sorter t/r and agg have the option sorter property...

2169


What is meant by incremental aggregation?

1095