DSXchange

Thanks. For now I will try to setup the Information analyzer to profile from flat files To make it read TXT and CSV files I defined the following driver in .odbc.ini and made an entry into uvodbc.config Driver=/usr/IBM/InformationServer/Server/branded_odbc/lib/VMtxt22.so Description=DataDirect TextF...

We have the tool installed on AIX version 5.3

It is a unix based tool

Can information Analyzer access MS Access databases.

If yes how.

Can information Analyzer access flat files to profile or is it pretty much tied to databases which can be accessed via drivers on the unix hosts

What is the difference between setting a meta data to be

NVarchar

vs

Varchar with extended Unicode property set


One thing I found is if NLS is not installed we do not get the option of setting the extended property

Where would should one use vs the other

I would really like some in understanding how the internal character conversions happen In my px job the default nls map is converted to an internal represenatation in px job which is uTF-16 (is this correct) and then it will convert back to what is the target character map again project default if ...

Ok I resolved it but I woud still not mind an explanation on how it really worked After spending a long time going over post in this forum and looking aimlessly at my warning message, I decided to make the description column to be NVARCHAR at sequential file and the target BW field meta data to be N...

I also did not understand why it refers to UTF-8 when I do not refer that at all at project level or job level

Hi All Thanks for the responses :-) Just kidding.. I know this is kind of tricky but thought of responding back with the answers we found after several tries with IBM support. Apparently when you invoke a process chain ONE MUST GIVE OR PASS A INFOPACKAGE along with the process chain to invoke. That ...

We would like to invoke a PROCESS CHAIN in BW which would in turn run BW PULL infopackages to invoke DATASTAGE jobs to load data to BW. First Problem It seems we cannot invoke a process chain without associating it with a INFOPACKAGE. In order to invoke a process chain we have defined a dummy INFOPA...

We are using version 8.0.1 and the associated versions of BW packs I have a question on invoking PROCESS chains. It seems I have to give a infopackage and CANNOT simple kick off a process chain. We designed a process chain that will pull or invoke two datastage jobs to get data and flow the data all...

Thanks a lot for the suggestions.

I am a little behind but will probably digest all this to try out a few scenarios later this week

I will post back what I find out

Thanks again for the explanation it helps

Regards
Arvind

I did change it as the angle brackets would not compile

I will try it again and post here shortly

It would become red as an expression indicating something not syntactically right but maybe I missed something let

I will post backhere shortly

Thanks that indeed seem to help I cleaned out the folder mentioned earlier in the folder and it seem to run the jobs just fine What is the.started file ( I am assuming it keeping some kind of trace points) but I just checked the directory for completed job and I do notsee a .started file. Is it a te...

I see what you are saying. I have deleted that. Let me run it and let you know what happens

Thanks a lot for your help


Sigma

Thanks I do not see any starter file /usr/IBM/InformationServer find . -name ".starter" -print 2>/dev/null returns nothing Also the rfc server is up as we are getting messages into the path /usr/IBM/InformationServer/Server/DSBWConnections/SAPBWD/SourceSystems/DATACLD/Data and files within...

Basically in BW the job is hanging for us when it get invokved there to runa datastage job