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
- 8846 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 are the different versions of informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
As union transformation gives UNION ALL output, how you will get the UNION output?
whats the logic to load the lower level of granularity of data to fact table.
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
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
Explain joiner transformation in informatica
Reusable transformation and shortcut differences
Where can we find the throughput option in informatica?
EXL informatica Questions
What is the difference between router and filter?
What is an unconnected transformation?
How identifying bottlenecks in various components of informatica and resolving them?
where to store informatica rejected data? How to extract the informatica rejected data?
how to create user defined function (udf) in informatica
