Hi All.,
I have a flatfile as a source with 12 record. In testing environment when i test the row count in target table (teradata) the row count is only 11…Any idea??? The job was succesfully executed
paul.bods (BOB member since 2011-06-29)
Did you choose DISTINCT Option in the query transform ?
Turn on your job in Debug mode and see what comes out after the Query Transfrom?
ganeshxp 
(BOB member since 2008-07-17)
Hi Ganesh.,
Thanks a lot for your reply…I didnt use Distinct option. I have 12 rows in the source file, but when i run in debug mode i can see only 11 rows comming out of source file and all these have been loaded into target…
Any suggestions???
paul.bods (BOB member since 2011-06-29)
Then I suspect some settings need to be changed on your File Format Editor? Is the 1st Record getting skipped? If so There are options to skip 1st record and couple of other options. Post me with a snap of your File Format and I could figure it out
ganeshxp (BOB member since 2008-07-17)
yes I got it…
Thanks a ton Ganesh…:):)
paul.bods (BOB member since 2011-06-29)