In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
- 4 Answers
- 8109 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajkumar_bachu
By using Normalizer transformation we can normalize the data.
| Is This Answer Correct ? | 2 Yes | 1 No |
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 |
How/where can i install Informatica software with oracle or teradata as database
what is bitmap index? did u use it?and how to use it in informatica
To achieve the session partition what r the necessary tasks u have to do?
how to join two flat files in informatica?
we have 30 wf with 3 batches means 1batch=10 wf 2 batch=10-20 wf 3batch=20-30wf through unix First you have to complete batch ofter second batch have to run how can you do in unix?
How you know when to use a static cache and dynamic cache in lookup transformation?
can we use union transformation in joiner transformation?how?
1 Answers Dabur, Tech Mahindra,
Why sorter is an active transformation?
What is the maplet?
What r the type of indexes u generally used in informatica?
Why you use repository connectivity?
What are the differences between oltp and olap?
Teradata 
