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 |
Can you start a session inside a batch individually?
What is the difference between Bad file and Reject file? and Where u can see the Reject file? What records stored in Reject file?
What is the difference between procedure and stored procedur?
How to jion 2 tables, without using any condition?
In which scenario did u used Mapping variable?
What are conformed dimensions?
Is it necessary to maintain the primary-foreign key relation ship between the targets in informatica while loading using constarint based loading or it is required only at database level ??
How to handle decimal places while importing a flatfile into informatica?
i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source
Describe data concatenation?
what is dynamic cashe
Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?