i wnt to truncate the data while reading the from source

sekr · Post by **sekr** » Mon Dec 19, 2005 4:29 am

Hi !
my source system is DB2 i have to truncate the records from source while reading source ..

how it can be done

MukundShastri · Post by **MukundShastri** » Mon Dec 19, 2005 6:53 am

Can you elaborate what you want to say. Give an example.

Mukund

sekr · Post by **sekr** » Mon Dec 19, 2005 7:28 am

I dnt want any data while reading the table from DB3 Table.

example :-
tabel <emp >
dob name
05/05/2005 simi
06/06/2002 rimi

while reading source i dnt wnt this data.

ArndW · Post by **ArndW** » Mon Dec 19, 2005 7:39 am

Sekr,

my first thought is that if you don't want the data, don't ask for it. Remove the extra columns from your query so that they are not processed. But perhaps I have mistaken your intent on your 2 posts.