DSXchange

Hi, from this topic its seems like there is no way we can accurately identify active users, but do we have anyway just to list all users, their role and which project they have access too. We do audit of all users, their roles and access to project. Currently we are retriving the userlist manually b...

Check what is set for APT_PADCHAR at the project level

I didn't use the expression builder of the transformer. I just map the Env vaiable defined in the job to the coresponding parameter in Container Property, and then i am using the Container param in Transformer stage and File stage.

I am trying to call a Shared container from a job. The job design is File - > SharedContainer - > File the design of the container is -> Transformer -> File The job has a Env Param $FilePath = $PROJDEF. The shared contaiiner also has a parmater: Path = #$FilePath#/subdir. In the shared container the...

The container structure is, the moniter show the external source and lookup stage as the first one. This container is working fine in other jobs (external source) | inputdata -> surrogateKey - > Transformer -> lookup -> File | Modify stage -> (external source stage)

I am trying to run a job but do not process any rows if shared container is present but if i remove the container its starts working, the container is working fine in other jobs. Details of the job Dataset | File -> Lookup - > sortstage - > dataset |(reject link) Transformer - > (shared conatiner) W...

Hi, I am trying to exceute two SQL statments in the after SQL of MLOAD stage. First SQL is insert into a table and the second SQL is update of a saparate table. I want to excute both statements in transaction. But BEGIN TRANSACTION, END TRANSACTION , BT and ET doesn't work the report file say unreco...

Thanks guys for the solution but the problem is a bit different, its a migration project, i have changed the code to Teradata for more then 2000 jobs. now when i am testing the data i face this problem, i thought if there is some global setting that i can do which will fix the problem else i have to...

I am trying to extract data from a teradata table with the defination CREATE SET TABLE decimalerror ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( Col1 DECIMAL(5,2)) PRIMARY INDEX ( Col1 ); The following data is then inserted 50.00 124.00 12.00 167.09 When i try to retrieve...

DS_Focusgoup, what was the resolution?

I am calling SQL file from After SQL of Teradata Connector stage, one of the table name is dynamic, is it possible to pass table name to the file from the connector stage

If you are using the instage sort then try using a saparate sort stage before partioning, it worked in my case

I Have names of PX jobs about 400, and i want to find out the names of sequences that call these jobs, My question is
1)Is it possible to find out this information through some Unix script?
2) Is it possible use the advance search facilty of Datastage from command line?

If suppose the shared continer is called from a multi-instance job, more then once then i want the temp table name to be different in both the calls, sorry if still not clear then i will try to explain more, thanks for your help

Unique per shared container call, i think Creating table name from Timestamp or from job PID will work, but the only place where i can write a routine to generate unique names is transfer stage but even after creating a unique name in the transformer how will i use it in place of tablename? You have...