Answer Posted / balaji

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.

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

Explain connectivity between datastage with datasources?

938

---

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

950

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3263

---

Why do we use exception activity in Datastage?

1226

---

What are stage variables and constants?

1095

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

3965

---

Define repository tables in datastage?

1098

---

What are the different plug-ins stages used in your projects?

1026

---

What is the difference between orabulk and bcp stages?

965

---

Describe link sort?

959

---

Difference between data warehousing and olap?

1041

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3698

---

What all are the different way to run a job?

1026

---

What is datastage engine?

1118

---

What are the types of hashed files in data stage

1057

---