Answer Posted / subhash

SeqFile--->Transformer=====>TGTFile1,TGTFile2

1. in SeqFile, add the 'Row Number Column' property and
name it as 'Row_Number'
2. in the Transformer, give the constraint for TGTFile1
link:
'MOD(Row_Number,2)=1'----> all the ODD rows
give the constraint for TGTFile2 link:
'MOD(Row_Number,2)=0'----> all the even rows.


If we use INROWNUM in transformer, then we need to run the
transformer on 'Single' NODE configuration.

How do you schedule or monitoring the job?

1204

---

how to use self join using datastage ? can u tell me using stage how can we implemnet the self join

5115

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

777

---

Define APT_CONFIG in Datastage?

1073

---

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

2046

---

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

4188

---

Which warehouse using in your datawarehouse

2184

---

What could be a data source system?

1004

---

State the difference between an operational datastage and a data warehouse?

1131

---

What is a merge?

1162

---

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

1502

---

8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?

2205

---

How a server job can be converted to a parallel job?

1093

---

To see hidden files in LINIX?

1520

---

what is the use of materialized view?

1567

---