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?

Answers were Sorted based on User's Feedback



In a scenario I want to change the dimensions of a table and normalize the denomralized table which..

Answer / rajkumar_bachu

By using Normalizer transformation we can normalize the data.

Is This Answer Correct ?    2 Yes 1 No

In a scenario I want to change the dimensions of a table and normalize the denomralized table which..

Answer / har

use dynamic lookup

Is This Answer Correct ?    1 Yes 0 No

In a scenario I want to change the dimensions of a table and normalize the denomralized table which..

Answer / hemanth

use joiner.

Is This Answer Correct ?    0 Yes 0 No

In a scenario I want to change the dimensions of a table and normalize the denomralized table which..

Answer / 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

More Informatica Interview Questions

While importing the relational source defintion from database,what are the meta data of source U import?

1 Answers  


What is fact table? Explain the different kinds of facts.

0 Answers  


Explain how many types of dimensions are available in informatica?

0 Answers  


How to delete first 3 rows & last 3 rows in target table in informatica

6 Answers   TetraSoft,


how to load rows into fact table in data warehouse

0 Answers   Informatica,


LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  


What are the tasks that source qualifier perform?

0 Answers   Informatica,


i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


What is the different lookup cache(s)?

0 Answers  


What is the difference between view and materialised view?

4 Answers  


If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,


Categories