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
- 9219 Views
- I also Faced
- E-Mail Answers
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
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is a repository manager?
Why filter transformation is an active one?
Enterprise data warehouse your projects phase by phase explain?
draw informatica architecture 8.6 ?
can we override a native sql query within informatica? How do we do it?
State the limitations where we cannot use joiner in the mapping pipeline?
Why do we need informatica?
What is mapplet in informatica?
What is the use of target designer?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Why union transformation is an active transformation?
What is enterprise data warehousing?
how many types of dimensions are available in informatica?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
