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

In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?

Answer Posted / gvmahesh

By using Sequencegenerator T/R we can normalize the
denormalized tables.

Because, By using SEQ T/R we can generate surrogatekey
column.then we can define that as Primarykey column.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the reusable transformations?

1157


What is persistent lookup cache?

1026


How can we remove the duplicates from flat file source?

1029


What is the use of transformation?

991


Where do we use mapping variables in informatica?

1061


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

1340


Enlist the differences between database and data warehouse.

1115


What is different between the data warehouse and data mart?

1058


can anyone explain me about retail domain project in informatica?

7944


How do you change a non-reusable transformation to reusable transformation?

994


how we can load rejected record's at run time?(not through bad files)

2374


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

2145


What are the types of data warehouses?

1517


can any one give some examples for pre sql and post sql(Except dropping and creating index).

4105


What are the types of caches in lookup? Explain them.

969