DSXchange

What should be the output for: ID COL_a COL_b COL_c 1 a1 NULL NULL 1 a3 b1 NULL 1 NULL NULL c1 2 a2 NULL NULL 2 NULL NULL c2 for the records starting with ID = 1 for the above data? Each column can only have one not null value for each unique ID..This has been ensured Thanks, Kanchan

Hello, I have a requirement that takes a source as in the sample[ number of columns go up to around 100 in actual]. The columns are varchar. I need to compress the rows and produce an output as in the sample. I tried using Aggregator Max function to extract the not-null value in each column with a g...

It seems that if the cpp file is compiled with the compiler name provided in APT_COMPILER option(as it is cxx in my case),then only the parallel routine would work. while trying to compile with cxx(a part of mks toolkit), the following error comes: C:\cygwin>cxx -c sum.cpp NuTCRACKER not properly in...

Thanks iDomz. I think my .net installtion do not have that part.though I could find the exe file, while trying to use it, it says This application has failed to start because mspdb71.dll was not found.Reinstalling the application may fix this problem Anyways, I think it does not matter if g++ can su...

Hi, The problem is because of while creating new parallel subroutine,in the General tab : External subroutine name = should be the Function name specified in your C program. Check the External subroutine name as per my understanding it should be ObjTestOne :wink: Yes it is a criterion. As I have me...

g++? Are you not supposed to have VS compiler in windows? I have a cygwin environment created with g++ installed. The same process as I have stated works in a AIX system if I use the DS specified compiler to compile(but g++ do not work). But while tring to use the datastage specified compiler(APT_C...

Hi Experts, After an extensive search for a solution in the forum, I fail to figure out the solution and hence posting the problem.Please do not ignore as there are already a good number of posts available. I have created a cpp file and have compiled with the below code: g++ -W/TP -W/EHa -DAPT_USE_A...

What (stage type) are you looking up from and how have you declared whether it is a normal or a sparse lookup? ... Hi ArndW, Thanks for your reply. I further investigated and could resolve experimentally. Actually when I connect a new lookup stage into an existing flow by detaching a link and conne...

Hi All, I am facing a weird problem while working with lookup stages. In some of my jobs, I have cascaded lookup stages and in the lookup stages having one reference link,I fail to provide a condition like IsNotNull(<source key field>). The Input column tab is disabled by default and do not accept i...

Hi, Thanks to Ray and Kim for your valuable inputs.I am confused with two points: First, does DS_JOBOBJECTS hold any information about the associated schema of column definitions..or it is assigned at runtime..I did check the structure of DS_JOBOBJECTS, but could not find any..also this is not docum...

Thanks Ray,

Well My plan is to access the metadata using the link names and get them saved in the saved category of DS_METADATA table.I was going through some of the posts which include routines by you and Kim...can they be inherited to suit this requirement?

Thanks,'
Kanchan

Hi friends, In our project we have multiple datasets being created as reference for lookups.For ease of reuse,I wish to save all the column definitions of the datasets into the saved category of table definitions.As the number of datasets are huge,manually opening up each job and saving them will ta...

Then, in a typical DW environment the best way would be to keep that default date throughout all your staging area and make them null in the final database..on which your reporting tool will work.

I am not sure abt Dynamic RDBMS stage...as my client didnt agree upon this to use..
Thanks,
Kanchan

Hi,
We used to get this error in similar situation using oracle enterprise stage.No straight forward solutions yet..but defaulting the null values with a out-of-range date can be done.Later on a procedure can update those values with null in oracle.

Thanks,
Kanchan

I think we can do this by the clean-up resources option in the director..the PID of the locked job will be shown..

Thanks,
Kanchan