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 / ankit kansal

Answer Posted / ankit kansal

Use a Rank Transformation and calculate rank on the group by basis on price and then using any router route your data to two different outputs.


http://deepinopensource.blogspot.in/

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1962

Can anyone tell me the new features in Informatica 9 Version?

2206

COM components can be used in Informatica

2450

What's the layout of parameter file (what does a parameter file contain?)?

2434

What is meant by lookup transformation? Explain the types of lookup transformation?

1019

expain about the tune parameters?

2457

How does a sorter cache works?

1109

What is fact table? Explain the different kinds of facts.

1123

What is a surrogate key?

1153

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1953

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

2028

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

1199

what is the hint? how to use it to reduce the query processing in program?

7972

can anyone suggest best free Talend data integration training online

1741

Where can we find the throughput option in informatica?

1107