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

How to transform normalized data to denormalized form in
informatica? Is there any logic or any transformations to
achieve this?

Answer Posted / ani

We cannot use normalizer transformation in this case.
It used for normalizing the records.
Use decode in expression transformation and then aggregator
transformation.

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please let me know how to make encryption and decryption with example?

1943


What is the need for an etl tool?

1100


Difference between Data and Index Caches?

1198


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

1000


What are the various types of transformation?

1239


How can we delete duplicate rows from flat files?

1306


Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1305


How can you generate reports in informatica?

1079


How to update or delete the rows in a target, which do not have key fields?

1219


Explain what is informatica metadata and where is it stored?

1103


What is sequence generator transformation in informatica?

1120


Define the various join types of joiner transformation?

1039


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1161


What is pmcmd command?

1177


How to join three sources using joiner?

1192