DSXchange

When i try to extract data from teradata view with ODBC stage, its running without any problem, the same one view running with TeraData Enterprise stage its giving the following error.

APT_TeraGenericQuery: not prepared

Thanks in Advance
IBMDS

Thanks Chulett,

Yes i need looping structure.
I would like to process all the dates within the quater. each time it has to process 90 days records.
can you please expalin with more details.
how to do it in sequencer job.

Thanks
IBMDS

In select statement i have to pass the parameters dynamically and its need to run through loop. dynamic sql where row_eff_date between #start_date# and #end_date# first time it needs to run from the start_date = 20050101 and end_date = 20050331 second time : 20050401 to 20050630 like this i have to ...

how to assign '1' for minimum line number and all the remaining line numbers to '0'.

I have to derive the column 3 based on the column1 and column2

Column1 column2 column3
100 1 1
100 2 0
100 3 0
100 4 0


Thanks

I am extracting data from comma and quote separted sequential file. for some of records the format like this and these records are dropped because of the following warning sff_XYZ,0: Field " XYZ_IND " has import error and no default value; data: {1 1 1 1 1 1 1 1 1 1}, at offset: 90 I verif...

This time its compiled very fast less than 1 minute. Thanks you all for the help.

Thanks

There are no process running on server. we have two nodes.

I verified with ps -ef | grep osh command.

Here is the design:

Sequential file -----> Transformer -------> Teradata(table)

in transformer checking for the len(trim(column1) = 0 then setnull() Else trim(column1)

Thanks
IBMDS

Hello, i am extracting data from sequential file(comma delimiter), it contains 120 columns. I am checking the (if Len(trim(column1)) = 0 then setnull() else trim(column1)) for all the 120 columns. The compilation is taking almost 20 minutes sucessfully. why its taking long time?, is there any possib...

I imported table using plug-in metadata definition. its float and i verified the table(show table in teradata). its defined as float.

Thanks
IBMDS

The source data looks like this

0.0302841
0.143932
0.044229
0.0474514
0
0.099517
0.00209654


Thanks
IBMDS

In teradata table, its float and in DataStage also defined as float

I am extracting data from sequential file and load into Teradata table, In table one column datatype is 'float'. Here I am getting the following error. Error when checking operator: Type mismatch for field 'RSK_NO'. Fatal error. Teradata_Enterprise_241: Error when checking operator: Input record and...

Here is the link

viewtopic.php?t=89029&highlight=differe ... hash+files

Thanks

What is the difference between 'Node pool and resource constraints' vs 'Node Map constraints'.

Thanks
IBMDS

when i try to run the orchadmin command in Sunsolaris..... I am getting the following error.

$ orchadmin check
ld.so.1: orchadmin: fatal: liborchgeneralsun4.so: open failed:
No such file or directory
Killed

Thanks
IBMDS