Do not use more than 3 nested IF. Use Evaluate statement in
case of more IF required. Please give a detail explantion
besides readability and clarity for Evaluate stmt.
No Answer is Posted For this Question
Be the First to Post Answer
hi all, i need ur help in preparing a sql which performs scd2, i mean i have a scd2 mapping i need a sql which can give me same result as scd2 mapping, SRC table: cust_no, loc 01 abc 02 xyz TGT table: pm_ky cust_no loc current_flag 1 01 abc Y 2 02 xyz Y cust 1 has changed his loc to xyz then it loads into TGT table as below, pm_ky cust_no loc current_flag 1 01 abc N 2 02 xyz Y 3 01 xyz Y i need sql to get the above result, hope got me question, Any suggestion will be appreciate.. thanks, Vinod
How can we alter the data after creating a view
write a program for finding the union of two integer array in java?
How to find out the user exit for va01.
in IBM PC -AT.WAT AT REFERS TO?
hai i am mca 2009 fresher.please tell me which certification helps me to get an IT job faster which institute is good in hyderabad.please mail me to prasanna.1856@rediff.com
Differevce between arrays and array builders?
Tag for turning an image into a hyperlink is
I have try to write a record in a TDQ from a fle.... what are the steps to do... can anybody plz come with a solution
For C sharp,At the time of software is implemented at client site, is it required that client machine have C sharp(Microsoft Visual Basic) setup?
What is a dialog based program
What is easiest way to get the PL/i compiler,I didn't have found the compiler in my library. Is there any extra cost if we want to access the PL/1 programs?Actually we r having Mainframe rented training Ids