DSXchange

this is exactly what i did before and how i created the test files. i have read them individually with the same options for all and they work fine. it just gives me a problem when i try to read them all at once. i have done all the basic checks, but it does'nt work. and gives me the same errors. it ...

Hi, just playing around with the functionality of 'file pattern'which you can set in sequential files to read multiple files in a folder. i have four files in a folder a.txt , b.txt , c.txt and d.txt in folder E:\files when i read them individually they work all ok but when i change the property to ...

i am not sure who told you that teradata stored dates in varchar because it does not !! it stores them in an integer form always integer 4 that is

and for what you want try this:

cast ('07/24/1922' as date format 'yyyymmdd')



Teradata Certified Master V2R5

it means that the meta data you have defined for the sequential file does not match with the original file.

check if the file path is correct and you are loading the correct file.
also check if the metadata is for the file you are referring too.

these are usually the two causes for it.

thanks ray. can you please let me know what is the command to read the file ? what should i write in the command line of Execute Command activity .

Hi all, I have two jobs. the first one gets the max val for a column from a table and stored that in a file. odbc---->> seq file The second generates surrogate keys for the incoming records. seq file---- > surrogate key gen----- > output what i want to do is to pass the value which is stored in the ...

thanks charlie. got around that problem . not getting some create table issues for the work table. any ideas where it creates the work table orch_work in the enterprise stage before it starts loading? i do have access do the db where i am loading the data but still it gives me : Teradata_Enterprise_...

p.s i think the same answer would be for any other db other than TD.

When you do ETL by using TD utilities you are using the power of teradata server, which ofcourse will run faster and more effeciently than a DS server. Even if you use that SQL in datastage, you are just using DS as a wrapper and not utilizing its power. Thats what experience tells us for 2 differen...

Thanks ray .. i already imported the schema like that. the source length is int 10 and the target length in TD table is also int 4( which has length 10 in teradata) . it just gives a type mis match error Keep CUSIP_ID, pstn_bal_amt,pstn_share_qty,SR_CUSP_ID Specification: CUSIP_ID=CUSIP_ID Specifica...

Hi all, went through the forms pertaining to this but did not get much help. i am trying to load a file with four columns into a table. the mapping is like source_field: target_field SRC_CUSIP_ID (int 10) SRC_CUSIP_ID ( integer 4) PSTNBalance (dec 17) PSTNBalance ( dec 8) PSTNShareQuantity (int 4) P...

TD API reads the records sequentially and is preferred when you have to read small number of records although it does not have any limits pertaining to TD utilities. TD Ent stage is the only stage which can read and write in parallel and is preferred for large volume of data. it uses TeraRead and Te...

Hi, just a quick one. is there any limitations on the number of jobs that can run in parallel in DS both in server and parallel edition and can you limit the jobs that can run in parallel at a given time ? if i want to limit DS to run no more than 5 jobs at the same time in parallel .i.e. 5 jobs sta...

Ok did not know that ! pasting the dummy data again in quotes as you mentioned . As i said before there is no problem with the data. it is fixed width and i do not have problem when i use seq while in server edition with fixed width format property 208924886190AM Aizhu Khaalid94596025319311144970399...

Hi all, trying to read a fixed with seq file but i am getting a message which says short read encountered. i know one of the problems can be the file not fixed d.. but i dont think its the same case here as i have managed to read the same file in the server edition without any trouble. i am setting ...