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

I HAVE A SOURCE FILE CONTAINING
1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B
AND IN TARGET I SHOULD GET LIKE
1|A+B+C+D
2|A+B
3|A+B
WHICH TRANSFORMATION I SHOULD USE

Question Posted / ankit kansal

Answer Posted / ankit kansal

There is only one row as per the defined problem. so first you have to break down this one row into multiple rows as separated by delimiter ','.
1|A
1|B
1|C
1|D
2|A...
Now in Expression Transformation using some string functions and later using rank/aggregator T/S you can achieve your result...

http://deepinopensource.blogspot.in

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create user defined function (udf) in informatica

1305

How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

2034

Explain joiner transformation in informatica

1124

In informatics server which files are created during the session rums?

1115

What are the new features of informatica 9.x developer?

970

What is a rank transform?

1084

What are the types of caches in lookup?

1048

What are the advantages of informatica?

1012

What are the types of schemas we have in data warehouse and what are the difference between them?

941

How to create or import flat file definition in to the warehouse designer?

1068

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

7186

Differentiate between joiner and lookup transformation?

1102

What are the different components of powercenter?

1055

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2035

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

2003