DSXchange

Hi All, I did some analysis and found that the metadata in 2 DBs for this table is same and it matches with the one defined in job as well. Now, I have no idea what to do. I have switched off the failure on schema reconciliation issues. But, still want to know the reason why this is happening when w...

Hi Ray, Thank you for the response. I will start investigating in order to find the culprit column. Though the probability of having different definitions is very slim given the fact that we exported our UAT DB (RMAN backup) and imported it into an empty schema to create our pre production DB. So, i...

Yes. I know that and i can fix that. However, my question is the length in DB is same across all DBs then why the job didn't fail in other DBs and failing only in pre production DB?

Hi Craig, Thanks for the reply. Here is the error: SRC_DB: Schema reconciliation detected a size mismatch for column CC_CD. When reading database column WCHAR(min=32,max=32) into column WVARCHAR(min=0,max=3), truncation, loss of precision or data corruption can occur. (CC_DBSchemaRules::reportSizeMi...

Hi All, I have job which runs perfectly fine in DEV/UAT environment( DataStage & DB). However, when the same job was moved to pre production environment i started getting the schema reconciliation issue. I checked there is no issue with the schema but still the issue is there. I can change the j...

Hi Craig,

I do agree with your point. The good part is that I am able to get this working, this gives a sense of satisfaction.

Hi All,

This is done. I used the approach suggested by Ray and as usual it gave the required results. Ray Thank you for that.

Hi All, I have a requirement in which I have to read all the source rows (only one column in each row) and load them into a single column in target. The no of rows is not fixed. Example: Input Data: A B C D E F G Output Data: ABCDEF Any idea how we can do this. I have done the pivot but it is popula...

Hi Craig,

Apologies if the initial post was not clear enough, will pay more attention to this next time.

Thanks

Hi All, I found the mistake and once rectified it started working the way it should. The problem was that the increment to the input date column was not working properly and it was getting reset to the original value again. Once this was taken care of the loop started working fine. I am marking this...

Hi All, I need to implement a logic where in i feel i would have to do a lookup in a loop. The requirement is something like this: I have an input date and i check if the data is a weekend or a country holiday. I am checking the weekend by using WeekdayFromDate function and for checking country holi...

Hi All, Good Morning. I was searching for istool glossary in dsxchange and i have not found even a single entry regarding this. Seems to be , there is a facility available to take the export at top categories level using this commands (istool glossary export) My Requirements are as mentioned below W...

I have a set of multiple instance jobs in the project. Now we have to make a new set of jobs to make statistics of the time taken by the jobs in running and find out the job names with their invocation id taking the longest time to execute and then tune the respective job. I am unable to find a way ...

Hi All,

I am having a .dsx file with me. The jobs in the file are all executables. I want to extract the names of all the jobs that are present in this export. Please guide me if we have any method to do this.

Thanks in advance,

Hi All, I am getting the below mentioned issue when i am trying to run one of my jobs: DataStage Job 1706 Phantom 286 Program "DSD.StageRun": Line 626, Internal data error. Program "DSD.StageRun": Line 626, Unable to open the operating system file "DSD_BP.O/JOB.154583408.DT....