Interested to Buy Any Domain ? << Click Here >> for more details...
What is the default padding character?
- 3 Answers
- 15457 Views
- IBM, I also Faced
- E-Mail Answers
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 |
Wat is pre-load in Hashed file
Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
how to export or import the jobs in .ISX file
You enter values in a schema file for RCP and you also entered values in sequential file? which one will it take?
What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?
How can we perform 2nd time extraction of client database without accepting the data which is already loaded in first time extraction?
what is the diff between sequential file and fileset stages?
Is it possible to query a hash file?
What are operators in datastage?
How to Remove Duplicate using SQL?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
Teradata 
