Answer Posted / vijay

Hi Amar ,

Thanks for giving Ans.

But As per i knows The Above two properties will be used
for Fixed with Flat files only.

I am asking aoutbt Varible lenth flat files?

for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1355

---

What are the important features of datastage?

1098

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2023

---

What is merge stage?

1281

---

What is the command line function to import and export the ds jobs?

1126

---

What is the difference between orabulk and bcp stages?

1009

---

Can you explain engine tier in information server?

1106

---

What are the functionalities of link collector?

1066

---

What are the different kinds of views available in a datastage director?

1015

---

What are routines in datastage? Enlist various types of routines.

1080

---

How to read the length of word in unix?

1361

---

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...

1479

---

what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees

1075

---

What are the partitioning techniques available in link partitioner?

2258

---

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

1509

---