HOW WILL YOU IMPLEMENT SURROGATE KEY IN SCD BY USING SURR_KEY GENERATOR,THE VALUE OF S_KEY SHOULD NOT REPEAT EVEN IF THE JOB IS COMPILED REPEATEDELY?
4 18045i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?
4 10129i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?
2 9141Post New L&T Data Stage Interview Questions
What is a trigger? Why we need it?
What are the ones that can be used with pandas?
Is there anything like an ifdef for typedefs?
The ratio of Emissive to absorption power of heat by a body is equal to heat emitted by a perfect black body. Who said the statement
Differentiate between as2 and as3.
What is the five main product offered by tableau company?
What are roll up summary fields? : salesforce objects & fields
What are the properties of the eventargs argument when capturing keyboard events?
What is the use of aggregation when we have rollup as we know rollup component in abinitio is used to summarize a group of data record? Then where we will use aggregation?
Draw a simple diagram of PeopleSoft three tire architecture?
1. What do you understand by "Quality"? And how much, do you think "Quality" is important and why? 2. What do you mean by "Analyst"? What is the difference between a "Quality Analyst" and a "Quality Controller"?
What are cross object formula fields?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What is the purpose of routing protocol?
what are the different types of base classes used in web-part?