Un-Answered Questions { Data Warehouse }

What is the commit type if you have a transaction control transformation in the mapping?

628


How can we improve session performance in aggregator transformation?

647


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

793


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

589


What is Data Caches size?

635


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

641


Explain load alternative records / rows into multiple targets - informatica

650


Explain lookup transformation in informatica

626


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

553


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

595


Explain about cumulative Sum or moving sum?

596


Explain lookup transformation source types in informatica

671


What is a transaction control transformation?

741


Define mapping and session?

565


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

868