Answer / datastage4you

It depends, generally, 4, 6 or 8

Can you explain engine tier in information server?

0 Answers  

---

How To find the location of APT_confid file

2 Answers   CTS,

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

What is a merge?

0 Answers  

---

How many nodes supported by a one cpu in parallel jobs?

3 Answers   IBM,

---

What are some different alternative commands associated with "dsjob"?

0 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

what is data mapping

2 Answers  

---

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 Answers  

---

i have a scenario like two columns(Empno, Ename) in that duplicate records are there, so my question is how to get second duplicate record in datastage.

4 Answers   Wipro,

---

count number of deptno in a emp table?

2 Answers   IBM,

---