Un-Answered Questions { Data Warehouse }

How can we improve session performance in aggregator transformation?

670


Explain direct and indirect flat file loading (source file type) - informatica

822


What are the basic requirements to join two sources in a source qualifier transformation using default join?

609


What is Data Caches size?

652


How do you promote a non-reusable transformation to reusable transformation?

658


Explain load alternative records / rows into multiple targets - informatica

679


Explain lookup transformation in informatica

642


How many ways a relational source definition can be updated and what are they?

574


What are the differences between joiner transformation and source qualifier transformation?

620


Explain about cumulative Sum or moving sum?

618


Explain lookup transformation source types in informatica

694


What is a transaction control transformation?

761


Define mapping and session?

581


Design a mapping to load the cumulative sum of salaries of employees into target table?

889


How to create or import flat file definition in to the warehouse designer?

609