wt is the use of truncate in bods

[Former Member]

wt is the use of truncate in bods ?? where we can use ??

[former_member205887]

Hi Kishore,

Your question is not clear, which truncate are you asking about...

[Former Member]

in bods . i got a question in interview ?? so i am asking ..

[former_member200473]

Hi Kishore ,

Request you to not use short form "wt" kind of language.

Please explain query in  understandable manner.

Thanks,

Shiva Sahu

[Former Member]

OK THANK U FOR REPLY.

WHAT IS THE DIFF BETWEEN TRUNCATE AND APPEND IN BODS ??

I FACED THIS QUESTION IN INTERVIEW ??

AS PER MY KNOWLEDGE BEFORE I DIDN'T LISTEN THIS WORDS IN BODS ..

IF YOU KNOW ABOUT THIS PLEASE CLARIFY MY DOUBT

[venkataramana_paidi]

Hi Kishore ,

There is no append in functions .  It may be truncate the data  & append the data in the target table in the next runs.

If that question relates to target table  If you use delete before loading , it deletes the data in the target , if you uncheck  data will append to the existing data.

Thanks & Regards,

Ramana.