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

Global and Local shortcuts. Advantages.

0 Answers  


What is limitations of truncate and load option

1 Answers   Cap Gemini,


can you avoid static cache in the lookup transformation? I mean can you

1 Answers  


how do u get the first record from 50,000 records ?

10 Answers   TCS, UBS,


suppose my source is 101 a 1o1 b 101 c 101 d i want target like that 101 abcd how will u achive this please give me the answer

1 Answers   TCS,


what we require for D.modelling?

1 Answers  


How can you define user defied event?

0 Answers  


How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,


Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?

1 Answers   IBM,


if i have source with 100 records target with 100 records and we lookup on another database table and it has 10 million record so what is the method of limiting that much record in lookup table?

2 Answers   TCS,


suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?

9 Answers   IBM,


If we have lookup table in workflow how do you trouble shhot to increase performance?

2 Answers  


Categories