when u connect the repository for the first time it asks you
for user name & password of repository and database both.But
subsequent times it asks only repository password. why?
Informatica server and client are in different machines. You
run the session from the server manager by specifying the
source and target databases. It displays error . You are
confident that everything is correct. Then why it is
displaying the error?
1)Power center server and client on the same machine
2)power center server and client on the different machines
What is the basic difference in these two setups and
which is recommended ?
A session S_MAP1 is in Repository A. while running the
session error message has displayed `server hot-ws270 is
connect to Repository B`.what does it mean?
list the transformation used for the following:Heterogeneous
sources,Homogeneous sources,Find the 5 highest paid
employees with in a dept,create a summery table,generate
surrogate keys
After installation of Cognos Reportnet how do i know how
much of entire Cognos server is being utilised at any
instatnt of time?
141
how can i text accracy of ETL migration? i am very new to
data warehousing. we are writing ETL scripts using
SCRIPELLA tool. how can i test the correctness of data.
and we are generating reports using pentaho . is there any
easy way to test the pentaho. how can test these ETL
scripts written in scriptella?
thanks in advance
236
HOW CAN WE SEE THE DATA IN DATASET?
32
Identifying the bottlenecks in various components of
Informatica and resolving them.
89
can cubes contain measures ?
79
how would u estimate the size of Lookup transform data and
index cache?
101
How will you use EME for view or publish metadata reports
using EME?
163
how u will design the report if the objects are available
What is a business view? and what is the difference b/w
business view and folder?in cognos report life cycle when it
will be involved ?
97
two sources S1,S2 containing measures M1,M2,M3, 4 dimensions
D1,D2,D3,D4, 1 Fact F1 containing measures M1,M2,M3 and
surrogate keys K1,K2,K3,K4
(a) write a sql statement to populate Fact table F1
(b) Design a mapping in Informatica for loading of fact
table F1.
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.
180
faq's on cognos
331
What is the difference between set functions and filter
function in dimensional data?
137
what r the main topics to prepare for the crystal reports?
could any on help me? i want to preparing for the
interviews? and also send any pdf file?
Site Map
