DSXchange

hi guys i have job to do. i dont know how am i suppose to do it. i have a job in which i have a sequatial file which has a file. now it load's the data to a teradata multiload. i have to modify that job into insert and update operation. splitting into two. means insert when when data not found and u...

actually the fast export was working fine the only problem was the sql query which had a trim in front of it and the date which was in the correct format already in the DDL so i just made changes to that and what you had told me about null values then it worked. thanks again What was the isssue? If ...

thanks kriss it works now thanks for your help Are you still getting the same error? As far as I know, the first error usually occurs when a fixed-width file is present. Set the delimiter to comma and quote to double. You are on Windows, so set record delimiter to DOS format. In the field default at...

well ok this is what i have in the format of the seq file

record level => record delimiter : UNIX newline
field defaults => delimiter = none

i dont have fixed length field length
so can u suggest me what do i do. i tried with what u had said but still its not working.

hi kris can our please tell what exactly the code i should be using. this is what i had coded but it is not working If IsNull(i/p column) then "" else i/pcolumn i even tried to change the data type to char from date, but its not working. i dont know whats the problem. the fast export has s...

hi kris my source is using teradata multiload that reads a table from teradata database and the target is actually three of them using a transfomer for all three. so the target is lookup file stage, sequential file stage which has a copy of the data in lookup and finally a dataset that will be used ...

hi every budy i am new to datastage. i am using teradata multiload to export a table from the teradata database. i have loaded the metadata, specified the SQL to be execuded and i think defined all the properties.i am using a transformer followed by a lookup and a sequential file. the error which i ...

u r absolutely right doma thats what i need to do, although i tried to do so with cdc but i guess the metadata is not matching. so what i plan to do is get each teradata into a lookup and then i can compare in a transformer and do inserts and update. i still didnt do it. but thats what i planned. I'...

i have two date four date column, it holds the business information. i have to modify two of them, one setting it to system date and one to null value. i can even use lookup also i guess. but i dont know whether it will work properly. the change capture does not read the data from the teradata EE.

sorry about that i told i was in a hurry

its a comparision between two tables. i am using a px environment and the source and target database is teradata.

I NEED TO KNOW HOW DO I DO THIS NEED TO DEVELOP A DELTA PROCESS THAT WILL DETERMINE THE DIFFRENCE BY COMPARING THE DATA FROM THE FILE RECIEVED FROM ONE TABLE WHAT IS CURRENTLY STORED IN ANOTHER TABLE. ALL THE ATTRIBUTES RECIEVED SHOULD BE COMPARED. THE UNMATCHED RECORD SHOULD BE UPDATED OR UPSERTED ...

thanks kumar
[
quote="kumar_s"]Gain more idea about software testing here. http://en.wikipedia.org/wiki/Software_testing[/quote]

hi guys did any one of u did any kind of system integration testing and user acceptance testing on a real data, not a dummy data. if anyone caould please tell me how does it work and what is the format of the procedure. i wanna know every thing about SiT/UAT. please if some can post me. i shall be v...

some times there is the format of the file which does not show propely
so its better to take tail than head

kumar_s wrote:head -40 should give you first 40lines, tail -40 should give your last 40 lines, apart from this, may I know what difference made your job to run fine?

right guys i made it work now i was reading the records from two files on unix server using the comman $head -40 filename1 filename2 > filename3 $head -40 filename4 filename5 > filename6 now the format of the data was not saved properly that why delimiter error occured so i tried "tail" in...