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 source like
X1 10
X2 20
X1 30
X2 40

i want target as
X1 X2
10 20
30 40 in informatica

Answer Posted / raji

Well,As of my knowledge.....
first u have to take eliminet the duplicates.....like
SRC---->SQ--->AGG---->TGT
in aggr t/f give the group by for both ports...
after this step just use a normalizer t/f to convert these
rows in to columns...

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Design a mapping to load a target table with the following values from the above source?

1343


What is informatica powercenter repository?

1200


What is the difference between a connected look up and unconnected lookup?

961


Explain the code page compatibility?

1059


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

2034


What are mapplets?

1265


Explain the use of aggregator cache file?

1248


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

2253


In informatica workflow manager, how many repositories can be created?

1354


is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1198


What is informatica? Why do we need it?

1092


What is olap (on-line analytical processing?

1064


What are Dimensional table?

1053


What is domain in terms of informatica?

1005


How to load the data from people soft hrm to people soft erm using informatica?

1008