1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / guest

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

What are the databases that informatica can connect to windows?

0 Answers  

Can you use one mapping to populate two tables in different schemas

2 Answers  

Why you use repository connectivity?

3 Answers   Yash Technologies,

How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,

Design a mapping to load the cumulative sum of salaries of employees into target table?

0 Answers   Informatica,




How many ways are there to create ports?

0 Answers   Informatica,

Can any one explain or sujjest some sites for scd mappings.Thank you

1 Answers   Wipro,

Why touse stored procedure in ETL Application?

2 Answers  

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.

5 Answers  

what is runtime variable?

3 Answers   TCS,

What is a router transformation?

0 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories