In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
Answer Posted / 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 View All Answers
How many dimensions are there in informatica?
Explain sql transformation in script mode examples in informatica
What is a dimensional model?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the main features of Oracle 8i with context to datawarehouse?
How do you change a non-reusable transformation to reusable transformation?
What is option by which we can run all the sessions in a batch simultaneously?
How to implement security measures using repository manager?
How can a transformation be made reusable?
How do we call shell scripts from informatica?
without table how to come first record only in oracle?
What is the benefit of session partitioning?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Implementation methodology