Suppose you have a report with no data , when you run the
report in report studio how can you tell the end user ,
that it has no data , while he runs it?Is it possible ? if
so how?
how do u estimate the depth of the session scheduling queue?
Where do u set the number of maximum concurrent sessions
that Informatica can run at a given time?
1
can anybody explain me in detail about software development
life cycle of business objects in detail?
17
Identifying the bottlenecks in various components of
Informatica and resolving them.
7
sas implementing companies in pune implementing clinical
projects if anyone knows plz send ans immediately
33
is there any difference between operational database and
data base?if yes what r they?
21
what is the difference between normal & bulk loading? and
which one is recommended ? why?
36
how to run two workflow(not a sessions) sequentially, what
is the process. Plz explain detailed information.
What is META DATA information in Data warehousing projects?
29
Hello,
I have PROC SQLs results group by 3 fields and I use SUM and
COUNT functions in SQL. The problem is when I try to display
my result with PROC TABULATE. I am getting very big
numbers. I believe I make a mistake some where in Tabulate.
Here is my Proc Tabulate.
PROC TABULATE DATA=OUT04_05 FORMAT=12.;
CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE;
VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE;
TABLE CENTRE ALL, (YR ALL)*VISA,
(NEWUSER*F=COMMA12. AUTUSER*F=COMMA12.
FRAUD*F=COMMA12. TRANSFER*F=COMMA12.
REISSUE*F=COMMA12.) /
MISSTEXT={LABEL='0'} PRINTMISS RTS=20;
FORMAT VISA VISAFMT.;
KEYLABEL SUM = ' '
ALL = 'TOTAL';
LABEL YR = 'DATE YEAR'
NEWUSER = 'TOTAL NEW ACCT'
TRANSFER = 'TOTAL TRANSFER'
FRAUD = 'TOTAL FRAUD TRANSFER'
AUTUSER = 'TOTAL AUTH USERS'
REISSUE = 'TOTAL REISSUE';
When I code it like : NEWUSER*N*F=COMMA12.
AUTUSER*N*F=COMMA12.
I get same amount numbers but to find a NEWUSER I use
COUNT(*) and to find AUTUSER I use SUM(xxxx) function so
both result shouldn’t be the same my problem is in this
point.
Could you tell me where the problem in code is. How can I
display my result?
TX.
49
Can u access a repository created in previous version of
Informatica?
11
what are the reporting tools and difference between them?
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map