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 18213i 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 10326i 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 9260Post New L&T Data Stage Interview Questions
SAP DEPRECIATION RUN ERROR: I have a problem with depreciation posting. I have searched the forum but did not find any answer. Net book value of $ 559,350 as on April 2012 was fully depreciated by 31 Mar 2017. Additions between April 2012 and March 2017 were correctly depreciated. However, additions from 01 Apr 2017 were fully depreciated when depreciation program was executed. For example, asset acquisition on 01 May 2017 $ 2400 was fully depreciated ($ 2400) which is not correct. It should be $ 2000*20%/12*11 = $ 440. Subsequently, in Jan 2018, on the acquisition of $ 207, the system has posted a positive depreciation of $ 47,469 on the base value of $ 1,640,423.72!!! More surprisingly, acquisition after that is correctly depreciated. For example, acquisition on Jan of $ 3,488.94 was correctly depreciated by $ 174.45 (3488.94*20%/12*3 months). Here are the details of the configuration of depreciation: · Depreciation method SLM · Base method 0014 · Useful life: 5 years (20% depreciation). · Period control 01/01/01/01 · Depreciation after the end of planned life – the box is “checked”. · There is only ordinary depreciation. · “Only negative values and zero allowed” checked in Rule for positive/negative sign for ordinary depreciation in Depreciation Area. · Fiscal year: April to March · SAP ECC 6.0 Can anybody suggest/help how to fix this?
Specify the port number for pop3?
Explain the Component of Storage-as-a-Service in Cloud Computing?
Why is it suggested to disable journalism in ext4 filesystem?
what are decleratives in cobol?
How do you write a powerpoint presentation?
How many rows and columns are there in excel 2008?
Explain the different exceptions in selenium webdriver.
Why SLS used as dissolution medium
What is the difference between the Standard and Professional Editions of Merge?
What is candidate key with example?
How can I use bugzilla in my company to track a bug and to allow the client to see the bug report online throughbugzilla. Please explain in detail. I am really need this.
Why do we use data structures?
What happens if an .swf is loaded into a already occupied level?
Can yum install rpm?