Answer / naga

where you guys find filter option in sequential file

Answer / charan

hi this is charan
in sequential file there is no distinct keyword.But we use sequential file properties reject mode=output and then use remove duplicate stage based on key column(here we can't store the duplicate records).

Answer / kiran

Hai Venugopal..,

This is kiran............

I tryied but im not getting proper result...please try
again please intimate me.........

Thanks you...................

Answer / manoj

By using "DISTINCT" key word can remove all the duplicates
in the record or file .......

Answer / venugopal

Hi Vijay it's simple

In the source sequential file goto Output->Properties
under options you mention reject mode = Output.

This will gives the duplicate records in the output.

This will 100% work why because in my present project we
are using the same format.

there are indexes on a table as index1 with col1, col2 index2 with col2 index3 with col1,col2,col3. if i run a query with col1='100' which index will be used and why

1 Answers   Virtusa,

---

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

0 Answers  

---

Hi frnds, my scenario is like i'm having a record 1234"1323£3434%343434^23232!1212$23232 in the above record all the special characters must be removed.how can we do it in datastage 8.0.1.can any one please ans this? thanx in advance

2 Answers   IBM,

---

source file having the data like aabbccc, i want target file result like a1a2b1b2c1c2c3.

2 Answers  

---

If I make any changes in the parallel job,do I need to implement the changes in the sequencer job,else the changes will be reflected automatically

6 Answers   TCS,

---

---

Hai..,This is Kiran M. What is D/B Change Capture stage and Difference stage?

2 Answers  

---

What are the different type of jobs in datastage?

0 Answers  

---

Define orabulk and bcp stages?

0 Answers  

---

Hi friends If anybody completed datastage 8.5 certification.Could please guide me what are the topics new in 8.5 certification.

2 Answers  

---

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

0 Answers   Syntel,

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?

1 Answers   IBM,

---