what is constraint based load order
Answers were Sorted based on User's Feedback
Answer / ahalya inturi
constraint based load order defines the order in which data
loads into the multiple targets based on primary key and
foreign key relationship.
| Is This Answer Correct ? | 10 Yes | 0 No |
The above answer with add one point we can configure the
constraint based load order in the Session Config obj tab.
| Is This Answer Correct ? | 1 Yes | 0 No |
Enlist the tasks for which source qualifier transformation is used.
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
By using Transformation i need top most 5 employee salary from each deptwise? Deptno 10,20,30? which transformation we need to use?
What is a joiner transformation?
A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )
Is there any model difference between ODS and DWH
what is constraint based load order
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
Explain the different dimensions.
What is the difference between informatics 7x and 8x and what is latest version?
What is the Difference between PowerPlay transformer and power play reports?