What is a snowflake schema?
No Answer is Posted For this Question
Be the First to Post Answer
What is the maplet?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
what is the use of Data Mart?
what is the architecture of any Data warehousing project?
How to create a non-reusable instance of reusable transformations?
Filter condition at workflow level & filter condition at mapping level . Which will get preference or which will work.
i have two source data there is no pk,fk how to join the two sources
what is the process of target load planing?
"Change cache" in Informatica ?