Recent content by yeewaitu

Hi, Does anyone know if Informatica can connect directly to SAS EAP? If so, what are the components that are needed to do it? Please advise. Thanks!

thanks for your help. =)

PID as shown below... Source Table ============ PID ID DATE === === ======= 1 123 01/01/05 2 123 01/01/05 3 123 01/01/04 4 123 01/01/03 5 124 01/01/05 Result Table ============ PID ID DATE Count === === ======= ====== 1 123 01/01/05 2 2 123 01/01/05 2 3 123...

Yes. I wld have duplicate IDs... sadly. =( Source Table ============ ID DATE === ======= 123 01/01/05 123 01/01/05 123 01/01/04 123 01/01/03 124 01/01/05 Result Table ============ ID DATE Count === ======= ====== 123 01/01/05 2 123 01/01/05 2 123 01/01/04 1 123 01/01/03 0 124 01/01/05 0

But what if there are duplicate dates per ID? How can you use temp table then?

can you show me how to do this in SQL 2000?

Hi, Got a SQL question for you experts out here. I would like to generate a count field based on the table below. Basically the count would reflect the number of records with the dates lesser than it and of the same ID. Source Table ============ ID DATE === ======= 123 01/01/05 123 01/01/04...

Any steps or documentation that one can find online for this?

Hi, I have an IIS 6.0 server that I have set up. In it, there is an application that can be accessed via http://localhost/xxx. However, I would like to configure my IIS such that I am able to access this web application using http://anyname.com/xxx from a huge group of computers. Please...

Yes. I have gone through this. It does not seem to work and I don't know why. Please advise.

Yes, I did that. But I still cannot get it to connect properly. Any advice?

Hi, Hmmm .. but there are only 3 components in the Reportnet CD. THe gateway, report server and CM server component. There isn't an access manager component which I can check. I need to connect to AD server .. do I need Access Manager? If so, how can I install it? Please help. =)

Hi All, Need your advice regarding this issue. I have 2 servers (win 2003 server) with reportnet and 1 database server hosting oracle 10g. One of them is hosting the reportnet gateway component and the web server (IIS), the other is hosting the reportnet report server and CM server components...

I would like some technical advice on the major differences between Cognos Impromptu 7 and 8. Please advise. Thanks!

I have found the answer. Just add the following environment variables under (System Properties > Advanced > Environment Variables) - ORACLE_HOME (path of oracle client holding the 'bin' folder) - CRN_ROOT (path of crn root directory eg: c:\program files\cognos\crn)