How could i automate the code in the scenario:Every month
one new data set will be created for that perticular month
transaction list.Now i would like to update the data in the
source table by appending every month data automatically.
feb---set jan feb;
mar---set jan mar;
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
Are you sensitive to code walk-throughs peer review or QC
whenever we using the merging through data set merging ,we can
get note in log like this "MERGE STATEMENT HAS MORE THAN ONE
ONE DATASET BY REPEATED BY VAIABLES" but the output has come
in good manner,whenever in in sql(full join) we can get
cartion product.so How do overcome this problem in sql?
How do you convert basic cube to transaction cube and
transaction cube to basic cube?
Is the physical structure of the data set in the same
orientation as the report? Do you need to reshape the data
sets? What method should you use to reshape the data–DATA
steps,PROC TRANSPOSE,output data set from a procedure?
Give e an example of..
what type of graphs we will create(for 2+years candidates)?