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

if i have records like these
(source table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
10001 gfhgdgh
10002 hjkdghkfh

the target table should be like these by using expression
tranformation.
(Target table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
xx001 gfhgdgh
xx002 hjkdghkfh
(that means duplicated records should contain XX in there
rowid)

Answer Posted / mfg

create an output port and write the expression to replace
values or create a stored procedure and call it expression
transformation

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the advantages of informatica?

1066


What does refresh system mean, and what are its distinctive choice?

1283


What is dynamic cache?

1091


Target increases every day even though no new record was inserted

1633


What is workflow? What are the components of workflow manager?

1235


What are the restrictions of union transformation?

1094


What happens when a session fails and you click on recover?

1192


have u done any performance tuning? how u ll do?

2370


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2205


write a query to retrieve the latest records from the table sorted by version(scd)

1129


lookup transformation with screenshots

4058


What are the designer tools for creating transformations?

1162


What do you understand by a term domain?

1184


Explain the tuning lookup transformation - informatica

1057


What is informatica metadata and where is it stored?

1056