DSXchange

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 .

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 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.

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.

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 ...

Is the row mismatch and the FTP problem related to each other?

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?

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.

hi i checked.i shows insufficient blocks for partition-no of partition.reading suppressed.

narasimha wrote:Is the row mismatch and the FTP problem related to each other?

no they r both different.right now i update my text using vi editor.copy-paste.but i have lots of file to transfer,so i need help?

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.

thanks narasimha.
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.

swades wrote:thanks narasimha
but actually i am running datastage from other system.
and there is no internet excess.sorry for that.

Did you issues get resolved?
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.