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

Difference between in process and inter process?

1308

---

What are the different options associated with dsjob command?

1486

---

What are the components of ascential data stage?

1243

---

How to implement complex jobs in data stage?

1162

---

Can you explain engine tier in information server?

1189

---

client know skid info?

2137

---

What are data elements?

1236

---

What are stage variables?

1257

---

Can we use target hash file as a lookup ?

3375

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2933

---

Whats difference betweeen operational data stage (ods) and data warehouse?

1172

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

1468

---

What are stage variables and constants?

1194

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2263

---

How do you start developing a datastage project?

1160

---