In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
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 |
While importing the relational source defintion from database,what are the meta data of source U import?
What is fact table? Explain the different kinds of facts.
Explain how many types of dimensions are available in informatica?
How to delete first 3 rows & last 3 rows in target table in informatica
how to load rows into fact table in data warehouse
LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?
What are the tasks that source qualifier perform?
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
What is the different lookup cache(s)?
What is the difference between view and materialised view?
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?