Answer Posted / mrvprasad

Take 4 field names(field1 field2 field3 field4) in output stage.

use Transformer stage: In Derivation use the below substring

Field1: SourceColumn[1,5]
Field2: SourceColumn[6,10]
Field3: SourceColumn[11,15]
Field4: SourceColumn[16,20] use this one u will get correct o/p.

Why do you need stage variables?

1230

---

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

1183

---

What are the different common services in datastage?

1337

---

how to add a new records into source?

2055

---

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.

4098

---

How a server job can be converted to a parallel job?

1142

---

How do you register plug-ins?

998

---

How do you schedule or monitoring the job?

1267

---

Difference between ‘validated ok’ and ‘compiled’ in data stage?

1350

---

Is it possible to implement parallelism in Mainframe Jobs ? If Yes how ? If no why ?

2323

---

What is the precedence of stage variables,derivations, and constraints?

1126

---

Define orabulk and bcp stages?

1178

---

Nls stands for what in datastage?

1237

---

What are the some differences between 7.x and 8.x version of datastage?

1306

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2100

---