How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
629Post New Informatica Questions
What does cheating measurement mean?
Explain the etl program with few examples.
What is the difference between router and filter?
Differentiate between source qualifier and filter transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the differences between oltp and olap?
-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?
Different sorts of metadata that stores in the storage facility?
What is complex mapping?
What is the need for an etl tool?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
Mention few advantages of router transformation over filter transformation.
What are the guidelines to be followed while using union transformation?
Can u generate reports in Informatica?
Explain sessions?