Answer / anchalthakran

Source file Input: abcdefghijklmnopqrs

Solution:- seq file---> transformer stage---> seq file

under function-->string-->convert function will give desired output.

Convert("j" , "z" , "abcdefghijklmnopqrs" )

Target file Output: abcdefghizklmnopqrs

Answer / 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

Explain Quality stage?

0 Answers  

---

i have data like sam ram sam raj ram I want two targets trgt1 ram sam trgt2 raj how can i do this in datastage?

4 Answers   IBM,

---

If seg file having 10 records ex:eid 1 2 " " 10 if oracle database having 100 records ex:eid 1 2 " " 100 how to delete matched records permenently from oracle database using datastage ?

5 Answers   Infotech,

---

How do you get log info into a file?

1 Answers  

---

whats difference between ls -ltr and ls -lrt?

5 Answers   L&T,

---

---

What is confirmed Dimension? what is Factless Fact? give one example? What are Additive, Semi-Additive Facts?

1 Answers   TCS,

---

How to reverse the string using SQL?

0 Answers   CTS,

---

1.what is repartionoing technique? 2.what deliverables transferred to client using datastage? 3.how to write loop statements using nested loop sequence?

0 Answers   IBM,

---

How to use Environment variable's in datastage?(use of process)

1 Answers   CSC,

---

Explain the functionality of your current project?

1 Answers   IBM, Miles Software,

---

What is a delta record? How you will read it?

0 Answers   EDS,

---

Please tell me What is difference between 8.0 and 8.1

1 Answers   IBM,

---