Ooops sorry.
This code was developed in 2001, I have never touched it since then. I know RDO is pretty old, we know in 2001 it self we thought of moving to ADO. I definitely want to move to new connectivity libraries (ADOs).
Now just wanted to start working on it. But to be honest say I like...
Hi VB Gurus,
I have few applications that where developed in VB 6. its pretty old code which i have developed long back.
We have a public module where we have code like this.
Cn as rdoConnection
Public Sub Main()
Set Cn=en.openconnection(...)
cn.open()
End Sub
We used the RDO library for...
Hi Informatica Gurus,
I have source data in normal case. I want to load upper case into the target table.
I know only the below synarios. Dont know if there is any other way to improve the performance.
Flat File Source.
1. converting into upper case using the TR package.
2. Using expression...
Hi, actually my search parameter changes dynamically. I cant use the pivot table wizards etc. I have to use this excel functionality with other tool, so i wont have option of wizards or manual intervention.
So when data in search parameter cell changes. I want to dynamically populate the sheet3...
I will pass the search parameter in the Main Worksheet of the same excel file. so it should get the parameter form Mainworksheet and do this work with in the excel file.
Regards
G
Hi Guys,
My source is Excel(.xls) file Worksheet1
COL1 COL2 COL3
US SALES 19
UK SALES 20
INDIA SALES 30
INDIA PUR 20
INDIA INV 50
CHINA SALES 15
IF I GIVE SEARCH PARAMETER AS "INDIA"
IT SHOUD POPULATE THE Worksheet2 WITH INDIA DETAILS
COL1 COL2 COL3
INDIA SALES 30
INDIA PUR...
Hi DB2 Gurus,
I have a situation where i have to use the subquery in the from clause. But db2 is failing to execute the query. Below query working fine in oracle but its failing in DB2 v9.
Dont know if its a known issue. please advise.
SELECT
dim.code, fact.amt
FROM
dim INNER JOIN fact ON...
Hi Informatica gurus,
Some one asked me a question like how can you pickup the source file name dynamically in the mapping with out using any unix scripting or paramfile etc. just using indirect file. Can someone answer me plz.
Regards
G
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.