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

Describe the architecture of datastage?

949

---

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

1044

---

Differentiate between hash file and sequential file?

998

---

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

749

---

What is the difference between hashfile and sequential file?

1185

---

Differentiate between data file and descriptor file?

988

---

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)

2327

---

Can you explain players in datastage?

1142

---

how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.

3263

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

1962

---

Why do we use exception activity in Datastage?

1226

---

What are the components of datastage?

1062

---

How do you reject records in a transformer?

1059

---

What are the benefits of datastage?

1171

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

1833

---