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 |
Differentiate between operational datastage (ods) and data warehouse?
EXPLAIN SCD
How u implement the slowly changing dimensions if my source table is consisting of cid,cname,add,phno,email but i need to capture the changes for first three columns how u implement?
WHAT ARE THE COMMON ERRORS IN DATA STAGE?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?
How can u write exception handling in seq 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.
What is the difference between server job and parallel jobs?
Hi friends, I am new to datastage, i have one query in datastage any one you please give reply to my post. I have a workbook (excel sheet) named as eg: xxxx, in that i have two tables emp(eid, ename, salary, deptno) and dep(deptno, name, state). in my source i have ODBC enterprise stage read the emp table and dept table join the two table and write the dept no 10(eid,ename,salary,name,state) values in target(). Thanks, Badari
What is a delta record? How you will read it?
How to enter a log in auditing table whenever a job get finished?