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

What are stage variables, derivations and constants?

1282

---

Why do we use exception activity in Datastage?

1368

---

On which interface you will be working as a developer?

1102

---

Nls stands for what in datastage?

1233

---

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3810

---

What are the benefits of datastage?

1301

---

Define Data Stage?

1140

---

What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2444

---

What is the purpose of interprocessor stage in server jobs?

2292

---

Define repository tables in datastage?

1202

---

Describe routines in datastage? Enlist various types of routines.

1052

---

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

855

---

why do u need the IOS upgradation in a FC switch

2334

---

Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?

1267

---

What are the different layers in the information server architecture?

1172

---