Answer / vinay kumar

unit testing:for example we are taking one job,for each
stage process will occure proper or not we will check.

integrating testing:combaining all jobs are running are not.

system testing:entire project will run (windows,unix...)

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---

Pls tell me what is troubleshooting in datastage view?

1 Answers  

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---

What is the default execution order of the sequential file?

3 Answers  

---

Which algorithm you used for your hashfile?

1 Answers  

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

1 Answers   IBM,

---

Hi, i did what you mentioned in the answer, i.e. source- >Transformer -> 3 datasets. Iam able to see the data in datasets but its not sort order... Can you tell how sort the data?? i also checked Hash partition with performsort.

1 Answers   CGI,

---

What is the method of removing duplicates, without the remove duplicate stage?

1 Answers  

---

Input Data is: Emp_Id, EmpInd 100, 0 100, 0 100, 0 101, 1 101, 1 102, 0 102, 0 102, 1 103, 1 103, 1 I want Output 100, 0 100, 0 100, 0 101, 1 101, 1 Means Indicator should either all ZEROs or all ONEs per EmpId. Impliment this using SQL and DataStage both.

6 Answers   IBM,

---

diff between changecapture & diffrence stage which situvation we can use the diffrence stage ?

1 Answers   TCS,

---

when will you go for dataset and fileset?

2 Answers   Accenture,

---

my source seq file have col1 1 2 3 4 5 6 7 8 9 i have 4 targets t1 t2 t3 t4 1 2 3 4 5 6 7 8 9 like this how we can get?

10 Answers   Polaris,

---