What is the default padding character?
Answers were Sorted based on User's Feedback
Answer / thilak
It is Null (0x0) -> hexadecimal value for null. This can be
set changed as per our requirement using the
$apt_padchar_string Env Variable
| Is This Answer Correct ? | 8 Yes | 0 No |
Well the Default Padding character in DataStage is NULL
(0*0) a Hexadecimal Value. And This can be changed to our
requirements by including Environment variable
$APT_STRING_PADCHAR and setting it to 0*20 as default value
then it will pad with spaces instead.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?
what is repositery?
What is audit table?
How to work with XML out put stage? Please explain step by step? i need to generate XML file using Table data. Given is the .XSD file. Please help?
What is job control?
Differentiate between data file and descriptor file?
hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys
Explain the functionality of your current project?
1 Answers IBM, Miles Software,
Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.
A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?pls pls
what are fact tables and dimension tables? give example assuming one table.