Answer Posted / naresh

Hi All plz saw the blow
first we read the data in seqential file
then taken transformer stage in tr stage we are create the two stage variable first stage variable like
column2 : colum1
then stage variable like
str(left(stage1,1),Right(stage1,1))
out put dragan drop the stage variable 
finally load the data in target.

What is the difference between operational data stage (ods) and data warehouse?

1169

---

Give an idea of system variables.

961

---

What are data elements?

1100

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1365

---

What are the difference types of stages?

1129

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

863

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

1021

---

What are the different type of jobs in datastage?

1000

---

What is "fatal error/rdbms code 3996" error?

1187

---

how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?

2127

---

How to reverse the string using unix?

3428

---

Name the command line functions to import and export the DS jobs?

1089

---

how to add a new records into source?

1934

---

Differentiate between validated and Compiled in the Datastage?

1191

---

What is the importance of the exception activity in datastage?

1014

---