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?
- 4 Answers
- 8809 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 |
Which transformation is needed while using the Cobol sources as source definitions?
Is stop and abort are same in informatica?
how to import multiple flat files in to single target where there is no common column in the flat files
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is confirmed dimension and fact?
What is rank transformation in informatica
How to load the data from a flat file into the target where the source flat file name changes daily?
How to jion 2 tables, without using any condition?
In a concurrent batch if a session fails, can you start again from that session
How do we do the Fact Load What is the size of your Data warehouse? What is your Daily feed size and weekly feed size
Explain factlessfact table with scenario
we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?
Teradata 
