DSXchange

1.PX job didn't run and only sequence jobs ran!

In the sceneraio i mentioned in a daily basis sequence job run and then PX jobs run but this time something wrong was going on because the majority of PX jobs didnt run only the Sequence jobs ran

Id appreciate your help in advance

Good evening Im a beginner with datastage and i need your help please with this scenario In a produccion system in a project A there are hundred of jobs, and when the processes starts ad midnight, everthing seem to be all right since those proesses are monitored throuh a thirdy party schedule tool l...

Good afternoon, in the company I work for in a production system has been implemented IBM Infosphere Datstage jobs and by means of Teradata manager can I see some code about Teradata SQL. honestly im new and im kind of lost, so Id appreciate your help if you can help me naming a good material to buy...

Good afternon : Im new at Teradata and Could anybody explain to me what this query does ? i dont understand the sentence CREATE MULTISET TABLE RCC_DATA.TMP_AboMovM_AcctSubs USING _spVV4 (DATE), _spVV3 (DATE)LOCKING TABLE DWH_DATA.ACCOUNT_SUBSCRIPTION ACCESS CREATE MULTISET TABLE RCC_DATA.TMP_AboMovM...

Understanding the expression USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS Good evening Im new at Teradata but in in Teradata Manager Tool in the explain tab i stumbled with the expression: USING _spVV0 (DATE)LOCKING TABLE DWH_DATA.ACCT ACCESS I tried to find out exactly what it means the ab...

Good afternoon I need your help please: Let me describe briefly the scenario to understand better my concern: In a Datastage application there are 1 sequential job (controlling job) and about 5 parallel jobs named p1, p2.. to p5. The dataflow for execution is this: sqn1 - p1 -p2 -p3 -p4- p5 - sqn en...

Good afternoon In Datastage as ETL tool i can connect to differeny RDBS and checkup its configuration by means of .odbc.ini file But checking out this file i can see entries for relevant information to acces the DB like Database, LogonI, Password just for only SQLSEVER database servers (Windowws Ser...

Good morning, in a Production System There are hundred of jobs extracting data from heterogenius and operational source RDBS like Oracle, SqlServer In Designer i click on each parallel job and it shows me by means of environment variabales the Database source connection. But the problem is that in a...

Im a dummy about Teradata and i have a question in an Production system there are hundreds of process that extracts information from heterogenous and operational database system, thors are RDBS like oracle, sqlserver, sybase etc. In Director Program graphically shows me which tables are accessing be...

thanks for your help

But where can i check out this and can i changed withotut any problem? if so how can i chage it

the 2nd quetion is if is there any command that let me know which tables a desired user has access and what type select,insert.etc.

id appreciate your help

Good morning: i need your help: i've got 2 questions: the first one is: i use bteq to connect to Teradata and i want to select the first 5 records of a table but returned just 2 columns. select top 5 * from DWH_LOG.procesos where nom_proceso = 'wedo_sqntbalanceexpire'; *** Query completed. One row f...

Good afternoon I need yor help because i havent been able to Connect to Tearadata using ds command shell: connect Teradata_Pro Enter username for connecting to 'Teradata_Pro' DBMS [dsadm]: dsadm Enter password for dsadm: SQLConnect error: Status = -1 SQLState = S1000 Natcode = -3004 [ODBC:-3004] [IB...

OK, thanks for your reply but with the sentence below why it yields the error message "the table doesnt exist?" , whats wrong with this sentence, or how can i move to the database where the table hosts and run the required select statement?

good afternoon. Now that i could connect to a Teradadata database using the information provided in the 3 mains files, i tried to run some selet staments but failed. for instance: select P.pARTY_sTART_dT, count(*) SQL+from DWH_DATA.INDIVIDUAL_NAME_HIST INH SQL+inner join DWH_DATA.PARTY P SQL+on INH....

The scenario is: all the datastages jobs run in a one server i.e 10.80.16.40 (unix server) but the teradata databases server are located in 10.80.4.20 So Under this environment and according what you have explain to me in the above message, in datastage there is not a "interactive" way to ...