Answer Posted / subbuchamala

In the Output Column Derivation of Transformer Stage:

1. Way:
Str('0',6-Len(string)): Input_Col--->Output_Col

2. Way:
right("000000" : Input_Col),6) --->Output_Col

3. Way:
Right(Str("0",6) : Input_Col),6) --->Output_Col
Right(Str("0",3) : Input_Col),6) --->Output_Col

Is it possible to query a hash file?

2013

---

What is a quality stage in datastage tool?

1081

---

what is flow of project?

2002

---

EXPLAIN SCD

1412

---

Can you explain repository tables in datastage?

1411

---

Can you highlight the main features of ibm infosphere information server?

1090

---

client know skid info?

2088

---

Can we use target hash file as a lookup ?

3327

---

how to export or import the jobs in .ISX file

1205

---

file having these input and we have to get 3 output using same job Input 1 1 1 2 3 4 4 4 o/p1 o/p2 o/p3 1 1 2 2 1 3 3 1 4 4 4

932

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2722

---

What is the difference between datastage and datastage tx?

1071

---

In Datastage, how you can fix the truncated data error?

1163

---

Difference between server jobs & parallel jobs?

1083

---

Difference between data warehousing and olap?

1097

---