Answer / Mohd Suhail

These are functions or commands in the IBM AS400 Data Description Specifications (DDL). Here's a brief overview of their purposes:
- Field: Defines a field within a record.
- NVL: Provides a default value if the specified field is null.
- INDEX: Creates an index on one or more fields to improve query performance.
- REPLACE: Replaces characters in a string according to a given pattern and replacement sequence.
- TRANSLATE: Converts each character in a string according to a specified translation table.
- COLESC: Copies elements from one dataset to another.

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

What is the difference between validate and compile?

1 Answers   CTS,

---

Hi guys, please design a job with derivation(solution). write exact conditions. My requirement Source table emp_no qualification 1 a 1 c 2 a 3 c 3 b Target table emp_no qualification 1 b 2 b 2 c 3 a Here every employer have three qualifications i.e a,b and c. what ever source table dont have some qualification, that will be move to target table. Like above. Hope u get the point. Thanks.

4 Answers   UHG,

---

What are the differences between datastage and informatica?

1 Answers  

---

What are system variables and sequencers in datastage

1 Answers  

---

what is materialized view used datastage?

1 Answers   HSBC,

---

how to delete one row in target dataset

1 Answers   Satyam,

---

what is the difference between the join and look up explin me one exmple

3 Answers  

---

Parallel job contains more than 20 stages. I want to find out which stage is more performance incentive.

1 Answers   IBM,

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

1 Answers   IBM,

---

What is the purpose of interprocessor stage in server jobs?

1 Answers   ASD Lab,

---

i have a scenario with i/p as ID,salary with values 1,1000 2,2000 and 3,4000 i need an extra column in the o/p named amount with values 2000,4000 and NULL. how can i get it?

2 Answers   L&T,

---