In a scenario I want to change the dimensions of a table and
normalize the denomralized table which transformation can I use?
Answer Posted / har
use dynamic lookup
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the status code in stored procedure transformation?
What is a dimensional model?
What is a passive transformation?
What is a predefined event?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
What are the conditions needed to improve the performance of informatica aggregator transformation?
How does a sorter cache works?
What is aggregate cache in aggregator transformation?
How to create or import flat file definition in to the warehouse designer?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What do you mean by filter transformation?
What are the different lookup cache(s)?
What are the reusable transformations?
What could be the possible resons of locks by user?
Explain dynamic target flat file name generation in informatica