DSXchange

Hi, As per my understanding of your requirement.. your requirement expected job flow like below 1) DB2 ->Lkp(<--- SQL) reference in look up stage mentioned in the condition- look up failure value=continue and read MD_id as nullable yes 2)then in the transformer write below derivation for those corre...

i think it might be useful
gunzip the file and spilt the file into multiple files and covert that job into multiple instances, parameterizing the source file name
and passing the source file parts at sequence level.

use the below procedure, jobactivity -> Execute condition -> UV Activity -> neted condition -> notification mail Execute condition:- cd reject file path;cat reject file|wc -l (if u r not passing metadat) UV activity > if nested condition.commnad o/p > 0 then 1 else 0 nested condition -> UV.activity ...

max how many stages we can use in single parallel job

u can do using only sort stage and sort the data in desc select first record using transformer stage (read transformer stage in sequential mode) and write constraint is @inrownum=1 if you need only one record.

Add to previous suggestions their is one more function IsValidTimestamp() try this it will genrate flag value, using this flag value u can filter the records

check that job(not able to view job log) log filter propertis has somebody may be changed for that job..check the job log options is there any auto purge or some one cleard the log.

Hi Ray,

can you please explain about VOC entry.

Thanks in advance

hello,

if you want to load the data into audit table. i can provide one server routine...

if you have an issue when loading
try multi load using teradata connector stage

hello Caig,

please help me how to write dynamic sql statements

Adavance thanks

follow the director and check which link is first check out the metadata...and i thought don't go deeply..

i may thought it may be the issue with Length of column or NLS try to change the length and check it once...

other try to use cast function and increase your length of your truncate clumn at the source level and passed that changed value to further stages..try this ...

Column_Import_75,0: Field "RECORD_TYPE" delimiter not seen, at offset: 2 my src data is fixed width file whic is iam geeting from reject link from seq file stage. 02SEARSLEGACY SEARSLEGACY SEARSLEGACY 801 HOME 608 HOUSEHOLD GOODS 008 HOUSEWARES 1 KITCHEN ELECTRICS 97 SEARS.COM 7 METALWARE ...

if you have any indicator for Hdr and trailor records then follow the below steps 1) from header record get the value of count using subsring if it fixed widh or u can use field function to get the count no from the header 2)in constraint exclude the hdr and trailr records based on your indicators 3...