In Datastage, how you can fix the truncated data error?
- 1 Answers
- 1243 Views
- I also Faced
- E-Mail Answers
Answer / Sandhya Sharma
To fix a truncated data error in DataStage:
1. Check that the target column width is large enough to accommodate the source data values.
2. Use the 'TRIM' or 'RPAD' functions to pad strings with spaces or zeros as needed.
3. Ensure that the character set used in the source and target match to avoid data corruption.
| Is This Answer Correct ? | 0 Yes | 0 No |
How you Remove the Dataset in Unix?
What are datastage sequences?
How do you get log info into a file?
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(
how to find diff between 2 dates without using Icon... funtions?
Unix command to view the data in a dataset
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
My input has a unique column-id with the values 10,20,30.....how can i get first record in one o/p file,last record in another o/p file and rest of the records in 3rd o/p file?
How do you start developing a datastage project?
If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?
Teradata 
