DSXchange

Are you using , user defined query or Auto generated, check the date format of the all date columns,if you are using user defined, try to check the date format example:- dd/mon/yyyy
All the best.

chulett
-Sorry for not providing full description.
SURA
- Yes, they are posting total files along with trigger file in one folder ,based on the module.
And i am trying with your logic, and update the status.
Ray -Thanks for your clarification and Thanks every one.

Regards,
Sree

Thanks, here my situation is not static it is dyamically changes for every file.
Kindly advice.

Thanks
Sree

Thanks every, still my issues is not resolved.

Is any other way to finish this task.

Thanks very much everyone.

I tried everything , if any one did in server job, please help me.

Regards,
Sree

Hi Floks,

I have a requirement, my source is sequential files and they want to populate filename to target table one of the column.
Provide me some logic to fulfill this requirement.

Request you to please help me to slove this issue.

Thanks
Sree

Adding my comments on top of below answer.

Try to do with few columns and in the server job's go to derivation tab and a column , b column give like this. may be you will get your expected output.

Thanks
sree

If you schedule job for particular time it will run the job automatically and it will show not schedule because job is already running at that time.
Can you please double check the job and result of the job and let me know.

Thanks
Sree

I dont have any idea about this, but some link i found it may be helpful to you.

http://www.forumtopics.com/busobj/viewt ... p?p=483261

Good luck.

Thanks
Sree

Try to load data in "Teradata MultiLoad" stage this stage is available in the palette, as per my knowledge your issue will be resolve with this. Try and let me know. Thanks Sree [quote="Venki-ds"]Hi there , I am loading data into teradata using teradata connnctor stage . Usually ...

Request you to reslove the status.
[quote="reachmexyz"]Thanks

That worked well.
I appreciate your quick help[/quote]

Input
20120422 3 3900
1121 990 1300
1122 991 1300
1123 992 1300

Output

1)Header record count and number records are matching we need to load data to audit table(number records or else aborte the job.
2) Data direct load to data table.

Thanks
Sree

Hi Everyone, This may be simple for some one, i am not able to find correct solution to acheive this requirement, all you are thoughts are acceptted. I have sourcefile with header and data ,this is in server job [b]20120422 3 3900 1121 990 1300 1122 991 1300 1123 992 1300 [/b] My requirement is to v...

I worked same sort of senario in server ,but i never used in parellel as per my knowledge on parellel, Try to check the table option, without commiting the table the records will not insert into table and i hope the below may be helpful to you. http://www.dsxchange.com/viewtopic.php?p=246588&sid...

Hey, Are you testing this job in dev or prod? 1)Dev:- Can you please double check all parameters are same as old job, some times in the administration, admin will change few parameters, due to that job may be aborted with fatal errors. 2) try to load the same data in to peek , if you are using parel...