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

Answer / shar

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.

Answer / sayani

'#' is the default padding character.

Explain the importance of surrogate key in data warehousing?

0 Answers  

---

i want send my all duplicate record one tar and all uniq records one target how we will perfome explain example: input data eid 251 251 456 456 951 985 out put/target1 251 251 456 456 out put/target2 951 985 how we will bring

13 Answers   Bank Of America, IBM,

---

when we will use connected Lookup & Unconnected Lookup

3 Answers   Wipro,

---

Can you define merge?

0 Answers  

---

how to create document in datastage?

1 Answers   Cap Gemini,

---

In a table 100 records are there after 50records job is aborted how can u insert all records in target table.

1 Answers   Cap Gemini,

---

SOURCE LIKE I_D,F1,F2 --------- 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 O/P LIKE ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y

4 Answers  

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

Hi guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

---

What's the Main Function of the Staging area in DWH

3 Answers   Oracle,

---

What is a datastage job?

0 Answers  

---

What is the use of Row generator stage?

2 Answers  

---