Un-Answered Questions { Informatica }

What are the differences between oltp and olap?

578


What are the types of schemas we have in data warehouse and what are the difference between them?

560


Differentiate between reusable transformation and mapplet.

621


Why update strategy and union transformations are active?

627


What is meant by target load plan?

596


How to join three sources using joiner?

609


How do you update the records with or without using update strategy?

706


What are the differences between source qualifier and joiner transformation?

624


How do you convert single row from source into three rows into target?

644


What are the types of schemas we have in data warehouse.

559


Why update strategy and union transformations are active? Explain with examples.

745


How do you load alternate records into different tables through mapping flow?

1336


How do you load first and last records into target table?

704


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

812


Explain in detail scd type 2 through mapping.

648