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

there is a product table

prodid prodname price

100 cinthol 10

101 hamam 10

102 neem 20

103 cake 30

in the above table the price of some products are
duplicated and some product prices are distinct we want to
push the duplicated prices to one target and non-duplicated
prices to other target without using expression and
sequence generator transformation

Question Posted / akash

Answer Posted / akash

Hi Krish,

In this case we will get distinct records in one table and
one record each for duplicate records of each table.

For ex:
Source:
101 neem
101 neem
101 neem

Duplicate target:
101 neem

Can you suggest any way through which we can get as many
duplicate records as there are in the source?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention few power centre client applications with their basic purpose?

931

What are the static cache and dynamic cache in informatica?

1171

What is a repository? And how to add it in an informatica client?

1128

How can you increase the performance in joiner transformation?

1181

How to load a Dimension ? and how to load a fact table?

1403

What the difference is between a database, a data warehouse and a data mart?

1142

Make a note of the quantity vaults made in informatica?

971

Differentiate between joiner and lookup transformation?

1094

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2083

Why do we need informatica?

973

What is complex mapping?

1106

Suppose we do not group by on any ports of the aggregator what will be the output?

1031

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

1090

Define filter transformation?

1082

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1143