In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
- 4 Answers
- 7508 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 |
What is DTM process?
What do you mean by channel change?
h0w many versions have been developed of onformatica so far?
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
can we see default group,when we use router?if yes how?
What is a data modeling?
Want to know about Training Centres for Informatica, Cognos and ETL Softwares in Mumbai, India.
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
Without source how to insert record to target?
I want to run a informatica worklow after complition of oracle procedure. That procedure is not running through informatica and can be run at any time in database. Informatica is in windows environment. Is it possible ? If yes please explain.
What are the types of data that passes between informatica server and stored procedure?
What is Collect performance data in informatica and what is the use of it.
Teradata 
