on how many columns we can perform aggregation in the aggregator stage?

2 Answers   Reliance,

---

what is the use of materialized view?

0 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 size of a transaction and an array means in a datastage?

0 Answers  

---

3) Sequential file contains data like Empno ename sal 111 abc 2000 Trgt file: Trgt1----111 Trgt2----abc Trgt3---2000

2 Answers  

---

Wat is isolation level and when do u use them?

1 Answers   HP, IBM,

---

i want job aborted after some records are loaded into output by using only sequential stage and dataset

1 Answers   IBM,

---

What is the different type of jobs in datastage?

0 Answers  

---

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

---

Hi, I have 3 records, 1 Srini 1 vasa 2 reddy now i want o/p like this 1 Srinivasa 2 reddy could u please help in this Thanks in advance.

6 Answers   Teradata,

---

What is the difference between validate and compile?

1 Answers   CTS,

---

im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination

0 Answers  

---