Answer Posted / trupti

InputField = "abcdefghijklmnopqrs"

step by step we can use transformer functions as,

1. left(InputField,10) ==> OP will be 'abcdefghij'

2. Use above output in
right (abcdefghij,1)= 'J'

The final derivation will be like below,

Convert(right(left(InputField,10),1),'Z',Inputfield)

Output :- abcdefghiZklmnopqrs

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

810

---

What are the types of hashed files in data stage

1108

---

How we can covert server job to a parallel job?

1153

---

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

1041

---

Can you explain players in datastage?

1203

---

Define orabulk and bcp stages?

1126

---

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

1086

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2295

---

Differentiate between hash file and sequential file?

1076

---

Explain ibm infosphere information server and highlight its main features?

1093

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

2224

---

What is the flow of loading data into fact & dimensional tables?

1067

---

Is possible to create skid in dim,fact tables?

2641

---

Can you define merge?

1132

---

What is the difference between account and directory options ?

1182

---