Answer / Narendra Pratap Singh

A Meta Stage in DataStage is a stage that creates, alters, or drops metadata within the repository. It is not used to move data.

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

---

How complex jobs are implemented in datstage to improve performance?

1 Answers  

---

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

---

How to remove blank spaces from data?

3 Answers  

---

on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

How do you design PX Routines ?

1 Answers  

---

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)

1 Answers  

---

it is possible to load two tables data into one sequential file?if possible how?plz share with me?

6 Answers   TCS,

---

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

---

How To find the location of APT_confid file

2 Answers   CTS,

---

How many types of sorting methods are available in datastage?

1 Answers  

---

Name the different types of Lookups in Datastage?

1 Answers  

---