DSXchange

What is the error message?

Any suggestion re the issue?

Hi, I searched before posting but could not find any solution to the problem I am facing. I am trying to implement SCD Type on Empl data just for checking how the stage works. The table in Oracle has following columns: SurrKey (SurrogateKey) ENo (Buss Key) Ename (Non Key - Type 2) Address(Non Key - ...

Are you doing any division operations in the last transformer? And if so, are he columns used for division have zero or null in them?

The reason of job getting may be different than the new link. What is the error you are getting? Also after adding 27th Ref link, try removing existing 1/2 ref linked. This way you still with 26 ref. If the job runs fine with the new ref link and with 26 only, then may be limitation of ref links. Bu...

After trying out few things, I was able to locate the issue. The input metadata column name was same as the variable and so error was reported.

Once the variable name was changed to make sure it is not same as the metadata, the issue was resolved.

Hi, I am trying to create a build op and below is the code used. Def: char LKP_KEY[20000][100]; int LenLKP_KEY[20000]; char OutputCol[20000][100]; int UniqueLength[100]; int RecCounter, UniqueCounter, i, j, k; Pre: i = 0; j = 0; k = 0; LenLKP_KEY[0] = 0; printf("Hello World!\n"); However w...

After doing a debugging for almost a day, we have found the issue was not with oracle. In the job we run a for loop to pick the files that match a pattern and External source stage. The cut command is being used and that command gives required fields. When the folder where we run the for loop has a ...

Forgot to add one more thing - it runs fine on Dev with same data. On prod though it is having these kind of issues. The Session monitor shows the wait is in "SQL*Net message from client". And the sparse lookup returns rows and still stays in wait.

Hi, We are facing an issue when using sparse loookup. We get thousands of files per day and the name includes date. Now if the file already processed comes again, we should not load it. We store the loaded file names in table FileNameControl. So when we start file processeding, we extract the date f...

I was getting a similar error today and found only one of the posts which talks about this message. After debugging it found out that if you do not define input or output schemas for build op or define an array with size 0 you get this error. Though it is very old post, thought of sharing the soluti...

Use a simple basic routine and here is a sample: DEFFUN svtGetLinkCount(JobName, StageName ,LinkName) CALLING "DSU.COUNT.FILES" ************************************************************************************************************************* * Header files to be included **********...

As you as you get this reply in logs, have you tried running the sequence2 manually or may be using DSRunJob? Is it working that ways?

Are you sure it is not the DRS extraction? Have you tried running a simple job to extract from DRS and load in DRS and check how long are they taking?

when job is running, what are the CPU and memory stats of the server?

Whatever I mentioned was to be done in the first job. Then call the second job multiple times for no. of rows created by first job. During each call, pass the filename from the file created in the first job. In the job using join with the original file and created file from first job, you can get th...