Answer Posted / chethankumar

take 2sequential files 1 funnel 1 filter 3 targets
1)load the files to sequential files
2)join both the records using funnel
3)in filter go to input tab perform sort enable stable
and in where clause give condition if col<6 one target
col>5 and col<11 second, third col>10

whom do you report?

1881

---

How many types of views are there in a datastage director?

1233

---

Where do you see different stages in the designer?

1034

---

Why do we use exception activity in Datastage?

1230

---

Hi,can any one please mention list of dimension and fact tables for Sales and Distribution System for a Pharmacutical company.

2226

---

What are the partitioning techniques available in link partitioner?

2228

---

What is the difference between datastage and datastage tx?

1010

---

Name the different types of Lookups in Datastage?

1214

---

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

1446

---

What are the different options associated with dsjob command?

1372

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4140

---

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

1032

---

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)

2330

---

how many rows sorted in sort stage by default in server jobs

3933

---

How can we improve performance of data stage jobs?

967

---