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.

What is the difference between orabulk and bcp stages?

1013

---

what are .ctl(control files) files ? how the dataset stage have better performance by this files?

2799

---

Describe the architecture of datastage?

996

---

How do y read Sequential file from job control?

15920

---

What is job control?

1098

---

What is the use of datastage designer?

1137

---

What is the importance of the exception activity in datastage?

1056

---

Explain usage analysis in datastage?

1147

---

What is difference between server jobs & parallel jobs?

1024

---

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

2262

---

Which commands are used to import and export the datastage jobs?

1404

---

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.

4022

---

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

3159

---

In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?

1493

---

Where do the datastage jobs get stored?

1191

---