In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
- 4 Answers
- 7819 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
What is sequence generator transformation in informatica?
What is native users?
What is rank index in rank transformation?
What is the difference between router and filter?
What is a joiner transformation?
what is Active lock explain
What is source qualifier transformation in informatica?
What are the types of data warehouses?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the tasks that source qualifier perform?
What is the benefit of session partitioning?
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Enterprise data warehouse your projects phase by phase explain?
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
wat are deployement groups in informatica, how it will be used for developers
