Answer Posted / prasad

Actually there are some small changes between 7.x and 8.x
1)In 7.x the repository was designed in file system but it
was RDBMS(db2) in 8.x
2)In 8.x the Datastage Monitor was merged along with the
Datastage Repository.
3)There was some new stages was introduced ,they are
--SCD
--Basic Transformer Stage
--New Surrogate Key Generator Stage
4)The Quality Stage and Profile Stage usage was available
in 8.x
5) 8.x Supports for Range Lookup
6)8.x version having good support for integration and
sufficent productivity.
7)There was some Developement changes occured in new
version they are,Advanced find,Imapact Analysis,Job
Reports,Resource Estimations etc..

What are stage variables?

1140

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1140

---

Is it possible to query a hash file?

1953

---

How and where you used hash file?

1113

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

2105

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2676

---

What are stage variables and constants?

1098

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

725

---

What is the differentiate between data file and descriptor file?

1307

---

Can you explain players in datastage?

1144

---

How many Key we can define in remove duplicate stage?

1314

---

What is a ds designer?

1024

---

What are the different type of jobs in datastage?

1002

---

State the difference between an operational datastage and a data warehouse?

1057

---

which r the connectors used in san?

2144

---