Answer Posted / poorna

these are mostly used in real time scenario:
database stages are:
1.oracle enterprise
2.tera data
3.db2
4.odbc
file stage are:
1.sequencial file stage
2.dataset
3.file set
4.hash file stage
processing stage are:
1.transformation
2.sort
3.modify
4.copy
5.funnel
6.lookup
7.surrogate key
8.join
9.aggregater
10 funnel stage
11.merge stage
12.Change Capture
13.Filter

debugging stage are:
1.head stage
2.tail stage
3.peek stage

How to manage date conversion in Datastage?

1115

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

2214

---

What is the difference between server job and parallel jobs?

1134

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2195

---

If you want to use the same piece of code in different jobs, how will you achieve it?

1132

---

Explain the situation where you have applied SCD in your project?

2017

---

What is the command line function to import and export the ds jobs?

1128

---

how to export or import the jobs in .ISX file

1180

---

whom do you report?

1913

---

Difference between in process and inter process?

1207

---

What are constraints and derivations?

1147

---

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

2170

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

992

---

What are the types of containers and how to create them?

958

---

project Steps,hits, Project level HArd things,Solved methods?

2105

---