Answer / hanug

To use environment variable at the project or job level, we
should first check if the environment variable already
present at the project level. If the environment variable
does not exist, we should create the one and then it should
be used at the project level or at the job level.

To use the environment variable you just need to add to the
project or job.

What is data partitioning?

0 Answers  

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

---

Unix command to view the data in a dataset

2 Answers   IBM,

---

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  

---

What are orabulk and bcp stages?

0 Answers  

---

root tree will find which is server job and which is parallel job?

0 Answers   IBM,

---

5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10

4 Answers  

---

Thanks to all people who are posting their comments...

1 Answers   CTS,

---

What are the prerequisites for join stage

2 Answers  

---

how may datastage variables/parameters will be in trnsformer stage? 1 2 3 4 ?

1 Answers   Wipro,

---

how do u reduce warnings

1 Answers   CGI,

---

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

---