Answer Posted / venkata ramana

Input Seq file:

CodeName
AB1
Aim2
Abnv5
1An8bx

Note: Column(CodeName) lenth is 6

Seq-->Transformar--DataSet

Trasformar:-

In Derivation cell:

Str('0',6 - Len(DSLink3.CodeName)):DSLink3.CodeName

Out put Dataset:-

000AB1
00Aim2
0Abnv5
1An8bx

What is a folder? Difference types of stages?

1115

---

I have a few records just I want to store data in to targets cycling way how?

2311

---

what is the difference between == and eq in UNIX shell scripting?

1445

---

How many types of sorting methods are available in datastage?

1029

---

What are the types of containers in datastage?

1146

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1521

---

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

3707

---

Define oconv () and iconv () functions in datastage?

1359

---

How one source columns or rows to be loaded in to two different tables?

1081

---

What is meta stage?

1140

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

1459

---

How to Remove Duplicate using SQL?

1305

---

table actions available in oracle connector?

1569

---

What are the various kinds of containers available in datastage?

987

---

how to delete one row in target dataset

3075

---