DSXchange

Hi Sir,

Could you please explain elaborately about the below design. For CDC we need two input links....

Below is your flow,

BeforeData --> CE(keys) --> CE (Value) --> CDC --> CI --> target DS

Thanks,

Why cant the last field can be split in to two with Nullable yes property and then combine in it further stages,if this schema going to be constant ?

Thanks,
Prem

Hello All,

Found a solution of using the strength of Before SQL in Oracle Stage where it will have a delete statement with extract date in it.So whenever a rerun happens with partial records in table,the before SQL will delete the records with date matching before being inserted.

Thanks,
Prem

Thanks Ray,

But the table dont have an option like timestamp or row id...is there anyway to achieve this.The only column is Extract date where we should have manual interference incase of any issues which is not allowed as per process.

Hello Folks, My Job design Job 1: Teradata Table -> TFM -> DataSet Job 2: DataSet ->TFM -> Oracle Requirement: To load all data from TD in to oracle without any transformation or conditions The TD table is temporary table which will get loaded in a daily basis with a truncate and load option. The Or...

Hi ALL, I am facing issue in teradata. Please find the description below and provide the solution to resolve this. how to load teradata table using TPT utility by enabling parallel synchronization. While loading we are facing the issue ISSUE: RDBMS code 2129: cannot read global variable, status = in...

Thanks for your help. It is working fine.

Hello folks, Job Design: Sequentialfile-->copy-->ftpenterprise stage I want to transfer the file to another server through FTP stage. In file it contains 50 data records and one header record has column name. The target server receives file which has only data records and not header record. Sequenti...

Sorry for the delayed reply. There are some ten update statements for a single table with different where clause and different joins with other tables. First we thought of using multiple ODBC stages as lookups and process these updates.Keeping performance in mind , all update statements are used in ...

Gurus, Job flow Row generator -----> transformer ------>ODBC stage I have been trying to update a sybase table.There are multiple update statements.(I had used Row generator and transformer for a dummy purpose)Due to restrictions, we are allowed to use ODBC connector stage where we created DSN for s...

Ray, As the number of source files are dynamic,sometimes 1 file and sometimes 60 files how can i decide the additional loop design to process. Also,the existing process includes fetching data from Teradata table(as reference link).If am using multiple loops,i.e.,same select query will be executed mu...

Craig,

1) Yes ,the files has to be processed individually.
2)Thanks,I will check this and get back on the outcome.

Hello All, There is an existing sequencer which process some N number of files and produce N number of outputs daily. Number of Source files are dynamic. It is passing through loop one by one and producing one file at a time.Need help on the following two concerns 1)This process is consuming a lot o...

Hi Folks, Am using Metadata Workbench 8.5 and trying to import a CSV file from windows, which is given as Sample import file in the tool itself. File name='Extension_File_Template.csv'. Got the below error. "ERROR: An error occurred while importing the file [IOErrorEvent type="ioError"...

Thanks for the reply.

I cant save my table definition as the metadata comes from a schema file(Parametrized) with RCP enabled.

We need to get run time information with Filepath,Filename,schemafile defined as parameters.