Give a way in which u can implement a real time scenario
where data in a table is changing and u need to look up data
from it.How will u configure the look up transform for this
purpose?
what is meant by drill through?(Mascot)
What is factless fact schema?
what are the different Reporting and ETL tools available in the market?
Explain and compare etl & manual development?
what is a worklet?
what is the difference between OLTP database and data warehousing database?
can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge
What is data modeling and data mining?
how to join two tables without using joiner transformation .advantages of joiner over lookup and vice versa.
what types of repositories we can create in informatica? in real time in which type of repository we will work on?
State the differences between shortcut and reusable transformation
without using ETL tool can u prepare a Data warehousing and maintaining?