not complete load table
Moderators: chulett, rschirm, roy
not complete load table
Hi all.
I m running a job.which load data to Teradata table.
But in my DS job is show 40 rows transfer ,i open that table its shows only 16 rows.
so plz tell me whats reason?
and also i use following FTP script to transfer file to Unix from windows.
but it shows me check username/password.
@echo off
echo open server name>d:\sampleftp.txt
echo username>>d:\sampleftp.txt
echo password>>d:\sampleftp.txt
echo put
file name path
echo quit>>d:\sampleftp.txt
echo bye>>d:\sampleftp.txt
ftp -vs:d:\sampleftp.txt
echo End of script
pause
Exit
so i run this script in .bat mode.
i getting error so plz tell me.thanks .
I m running a job.which load data to Teradata table.
But in my DS job is show 40 rows transfer ,i open that table its shows only 16 rows.
so plz tell me whats reason?
and also i use following FTP script to transfer file to Unix from windows.
but it shows me check username/password.
@echo off
echo open server name>d:\sampleftp.txt
echo username>>d:\sampleftp.txt
echo password>>d:\sampleftp.txt
echo put
file name path
echo quit>>d:\sampleftp.txt
echo bye>>d:\sampleftp.txt
ftp -vs:d:\sampleftp.txt
echo End of script
pause
Exit
so i run this script in .bat mode.
i getting error so plz tell me.thanks .
Re: not complete load table
Check the director. It seems that the rest of the data got rejected. Look into the Director's log for this job. You will see a bunch of warnings and the reason of rejection.swades wrote:Hi all.
I m running a job.which load data to Teradata table.
But in my DS job is show 40 rows transfer ,i open that table its shows only 16 rows.
so plz tell me whats reason?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Re: not complete load table
Hi ,
There may be any foreign key constraints in the database where you are loading . So check the datastage director to get more information and also check the schema for foreign key issues.
There may be any foreign key constraints in the database where you are loading . So check the datastage director to get more information and also check the schema for foreign key issues.
DSguru2B wrote:swades wrote:Hi all.
I m running a job.which load data to Teradata table.
But in my DS job is show 40 rows transfer ,i open that table its shows only 16 rows.
so plz tell me whats reason?
[/quo ...
Re: not complete load table
hi i checked.i shows insufficient blocks for partition-no of partition.reading suppressed.DSguru2B wrote:Check the director. It seems that the rest of the data got rejected. Look into the Director's log for this job. You will see a bunch of warnings and the reason of rejection.swades wrote:Hi all.
I m running a job.which load data to Teradata table.
But in my DS job is show 40 rows transfer ,i open that table its shows only 16 rows.
so plz tell me whats reason?
Check if this is similar to your first issue
viewtopic.php?t=96405&highlight=insuffi ... +partition
With your second issue with FTP, as per your error message says check the username/password
A couple of things I want to mention
- Post one issue per post, it gets more attention.
- Post exact error messages (copy and paste) rather than typing out the messages, There are chances that you miss some.
viewtopic.php?t=96405&highlight=insuffi ... +partition
With your second issue with FTP, as per your error message says check the username/password
A couple of things I want to mention
- Post one issue per post, it gets more attention.
- Post exact error messages (copy and paste) rather than typing out the messages, There are chances that you miss some.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.
thanks narasimha.
but actually i am running datastage from other system.
and there is no internet excess.sorry for that.
but actually i am running datastage from other system.
and there is no internet excess.sorry for that.
narasimha wrote:Check if this is similar to your first issue
viewtopic.php?t=96405&highlight=insuffi ... +partition
With your second issue with FTP, as per your error message says check the username/password
A couple of things I want to mention
- Post one issue per post, it gets more attention.
- Post exact error messages (copy and paste) rather than typing out the messages, There are chances that you miss some.
Did you issues get resolved?swades wrote:thanks narasimha
but actually i am running datastage from other system.
and there is no internet excess.sorry for that.
I am sorry I did not get your point, about not having internet on your system running datastage.
Try to resolve your issues one at a time.
You need to rectify, your issues with the dropping of rows.
Then you can go to the next step to rectify your FTP script. (Or according to your priority)
Giving details about the errors, this will help get answers more quickly.
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.