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

How can we improve the performance in datastage?

1093

---

how to write server Routine coding?

2100

---

What are the partitioning techniques available in link partitioner?

2261

---

explain about completely flow of sequencers technicaly,without using example??explain about lookup,nullhandling?

2473

---

DB2 connector> transformer > sequential file Data will be exported into a csv format in a sequential file. This file will be send in a email using a sequence job. Problem here is, how to avoid sending a blank csv file? When I ran the job there are chances that it might return zero records but in the sequence job csv file is going blank. how can I avoid this? thanks

1515

---

What are the different options associated with dsjob command?

1417

---

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

3739

---

Triggers,VIEW,Procedures

1214

---

root tree will find which is server job and which is parallel job?

1945

---

What are the some differences between 7.x and 8.x version of datastage?

1246

---

How to convert RGB Value to Hexadecimal values in datastage?

3981

---

Why do you need stage variables?

1170

---

What are the types of containers and how to create them?

963

---

Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.

2042

---

Define ds designer?

1253

---