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

How many dimensions are there in informatica?

1086


Explain sql transformation in script mode examples in informatica

1133


What is a dimensional model?

980


how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

2160


What are the main features of Oracle 8i with context to datawarehouse?

2112


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

999


What is option by which we can run all the sessions in a batch simultaneously?

1142


How to implement security measures using repository manager?

1178


How can a transformation be made reusable?

1168


How do we call shell scripts from informatica?

1120


without table how to come first record only in oracle?

2253


What is the benefit of session partitioning?

1116


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2554


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1866


Implementation methodology

1713