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 is the use of surogate key in datastage

2295

---

What is the project in datastage?

1092

---

Triggers,VIEW,Procedures

1209

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1482

---

in oracle target stage when we use load option and when we use upsert option?

2259

---

Why do we use exception activity in Datastage?

1282

---

Can you explain repository tables in datastage?

1383

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2488

---

Have you used Unstructured data?

1301

---

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.

4019

---

What is usage analysis in datastage?

1289

---

sed,awk,head

1445

---

What are transforms and what is the differenece between routines and transforms?

1041

---

What are the primary usages of datastage tool?

1057

---

Define APT_CONFIG in Datastage?

1054

---