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...

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

Answer Posted / guest

Aggregator with group by on column with values 1, 2, 3

Is This Answer Correct ?    7 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1056


What is the function of aggregator transformation?

1031


Explain transaction control transformation in informatica

1222


Reusable transformation and shortcut differences

1791


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2294


Why sorter is an active transformation?

1142


Target increases every day even though no new record was inserted

1524


can we override a native sql query within informatica? How do we do it?

1072


What are the different transaction levels available in transaction control transformation?

1137


What is the maplet?

1060


How to generate or load values in to the target table based on a column value using informatica etl tool.

1032


What is a passive transformation?

1049


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2037


explain one complex mapping with logic? sales project?

6613


What is meant by pre and post session shell command?

1116