Answer Posted / rr
A dimension that will remains unchanged in entire
datawarehouse. It can be used across all the fact tables.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
how many types of dimensions are available in informatica?
Difference between Target-based loading and constraint-based loading?
What is a surrogate key?
What are the components of workflow manager?
How we can use union transformation?
What is DR strategy for Informatica project?
What are the measure objects?
What is the Process to creating lookup transformation in informatica
what are 3 tech challenges/ common issues you face?
How to convert multiple rows to single row (multiple columns) in informatica
What is lookup transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Where can we find the throughput option in informatica?
Does an informatica transformation support only aggregate expressions?