how many types of dimensions are available in informatica?
No Answer is Posted For this Question
Be the First to Post Answer
In which transformation you cannot drag ports into it?
There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?
what is correlated query?
Can anyone tell me, when a flat file contains different kinds of delimeters available for each line ( For Ex: First line contains [,*&#$] and second line contains [%@$#%^]. Like that all records having different kinds of delimeters. How can we implement this kind of flat file in informatica?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
what are types of dimentions?
Briefly explain the aggregator transformation?
List the transformation used for the following: (1) Heterogeneous Sources (2) Homogeneous Sources (3) Find the 5 highest paid employees within a dept. (4) Create a Summary table (5) Generate surrogate keys
what are factless facts? And in which scenario will you use such kinds of fact tables.
Differences between connected and unconnected lookup?
What are Rapid changing dimensions?
What do you understand by SOA of Informatica?