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

Can we create multiple integration service on single repository?

1155


What is Data Caches size?

1059


waht type of interface is used for testing the data in informatica

2215


is it possible to index the data in cache of lkp transformation ?

1988


What is the difference between stop and abort in informatica

1057


Explain pushdown optimization and types in informatica

1038


Differentiate between a database and data warehouse?

1107


Is it possible to define a single node as a Gateway node as well as worker node?

1079


Which development components of informatica have the highest usage?

1005


What is the sequence generator transformation in informatica?

1128


Implementation methodology

1672


difference between informatica 8.1.1 and 8.6

3647


what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2276


what is the complex transformation you used in informatica

2548


Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1035