HI
THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY
SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS
POSSIBLE BY USING DATASTAGE7.5.
25
how do u place it in required folder
57
if a parameter is not send to a stored procedure what type
of identifier is to be used in Stp and if that parameter is
not feed to the a query inside the Stp how to validate with
out useing IF condition
What are statistics, under what circumstances they go out
of date, how do you update them?
69
what is data access layer?
33
we have 10 concurrent programs under one request group
out of 10 ccps all users submitting only 9 programs from
srs window remaining one ccp for specific user how can it
possible send me answer asap.
how to take backup bcp out for a column in table in sql
server?
27
Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer:select length(trim('ram charan singh')) - length
(replace
(trim ( 'ram charan singh'),' ','')) +1 from dual
The above query working properly when space between the
words is only one &similar
But ,If the space between the words is nonuniform.
Ex:'ram charan singh is good' ans:5
i am not getting this answer using above query.
40
Scalability, Availability, Integration with internet, etc.)?
42
can we delete autodiff back up that we have set through
sql server agent.
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map