DSXchange

You can check with the ASCII values

You can do the lookup in either of the below mentioned ways:

1) You can convert the leading zeros to space, trim the data with varchar datatype and then perform the lookup.

2) You can convert the field which you are looking up into Decimal datatype and then perform the lookup.

I have faced a similar problem with teradata multiload release. What I did is delete all the table contents and tried this command RELEASE MLOAD <TD-TABLENAME>. Then I tried to load again. It worked.

First you read the oracle table using ODBC stage. Next sort the records in ascending order using EMPLID, EMPL_RCD and EFFDT as key. Next use the remove duplicate RDUP stage using EMPLID and EMPL_RCD as the key and retain the last record. Thereby, you will have the record according to your requiremen...

Funnel stage will solve the problem. If you want sorted output, then you can try with the sort funnel option. Or else sequence funnel option is the best to my opinion as per the performance is concerned.

Yeah, you can try it with the Unix commands. But if any kind of manipulation is required then you may go for a shell script.

You can perform the delete operation from UNIX only if you have the priviledge for it. But you can also delete it with the help of datastage. You follow the process below. It will be deleted. TOOLS -> DATA SET MANAGEMENT Here select your dataset which you want to delete. You can take the help of the...

You can perform the read with the sequential file stage. And then can move the column values into your user variables. There are many stages with which you can do this. If you are simply moving the data into user variables then you can use a copy stage. If you are transforming the data you can use a...

It's a Teradata command, not a DataStage command. Because we don't know all the identifier names in your Teradata installation, we can not help. Ask your database administrator (DBA) for assistance ... I checked with the DBA. Actually I want to delete the Teradata tables before inserting data into ...

keshav0307 wrote:any DML

Is there any particular syntax for it? Could you please give me some examples?

I am currently trying to insert data into Teradata Mload table. It's working fine. But what should be the BEFORE CLAUSE that can be used so that the table may be truncated or deleted or released before it starts processing? Can anybody help me with the list of commands that will be applicable in the...