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.

Differentiate between operational datastage (ods) and data warehouse?

674

---

How do you remove duplicate values in datastage?

632

---

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

352

---

What are the types of containers in datastage?

705

---

What is size of a transaction and an array means in a datastage?

739

---

---

Why fact table is in normal form?

678

---

What is difference between server jobs & parallel jobs?

625

---

What are some prerequisites for datastage?

617

---

Explain connectivity between datastage with datasources?

599

---

What are the types of hashed files in data stage

646

---

Enlist various types of routines in datastage.

645

---

What is the method of removing duplicates, without the remove duplicate stage?

588

---

What are the main differences you have observed between 7.x and 8.x version of datastage?

624

---

Can you explain players in datastage?

709

---

What is the command line function to import and export the ds jobs?

681

---