Answer / rajesh.dwh

Function must returns value, but Procedure may or may not
return value.
Function can be use with select statement where Procedure
can't be used with select statement regarding ORACLE SELECT
statement.

how to handle null values in sequential file?

1 Answers   HCL,

---

I have scenario like this seq file --> transformer --> sort stage --> dataset In this job which prtitioning technique you are using and why???

3 Answers   CTS, IBM,

---

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

---

Is it possible to query a hash file?

0 Answers   IBM,

---

What is the default padding character?

3 Answers   IBM,

---

---

one file contains col1 100 200 300 400 500 100 300 600 300 from this i want to retrive the only duplicate like this tr1 100 100 300 300 300 how it's possible in datastage?can any one plz explain clearley..........?

8 Answers   IBM,

---

What are stage variables, derivations and constants?

0 Answers  

---

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---

Does datastage support slowly changing dimensions ?

0 Answers  

---

CHANGE CAPTURE

0 Answers   CTS,

---

Where do you see different stages in the designer?

0 Answers  

---