Answer / shar

see parallel jobs r by default optimized such that transformer stages only get recompiled if they have changed since the last compile. The force compile option overrides this and causes all transformer stages in the job to be compiled

Answer / bhupathi reddy

you have done some changes in satage properties (i.e some business logic has been changed)which has already ran job , if u compile the job the compilation would be effect on which ever u modfied (i.e in recent changed stages).when ever you do the force compilation entire job will compile again .

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

Create a job to load all unique products in one table and the duplicate rows in to another table. The first table should contain the following output A D The second target should contain the following output B B B C C Q2. Create a job to load each product once into one table and the remaining products which are duplicated into another table. The first table should contain the following output A B C D The second table should contain the following output B B C

3 Answers   Deloitte, IBM,

---

I have a file it contain 2 records like empname,company as Ram, Tcs and Ram, IBM. But i want empname, company1,company2 as Ram, TCS,IBM in the target. How?

6 Answers   Cap Gemini,

---

Hi all, can u explain header and trailer records in file? If a file has header and trailer /master-detail records how will you read it in datastage?

3 Answers  

---

how can i get 2nd highest salary in datastage?can u send me ,thanQ 2)if i had source has 2 records 1st record ie 1st column contains 1,2,3 and 2nd coulmn contains 10,10,10 i have to get target as 2nd columns as 20,30,40 how can i?

3 Answers   Accenture,

---

1.which index is follows the dimensions tables?why? 2.what is the use of trigger in job sequence? 3.what is the mean of optimization? 4.what is the job control?when we use it? what is difference bet batch and sequencer? 6.seq--->seq,seq--->copy--->seq which one is best and efficient?

1 Answers  

---

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

1 Answers   IBM,

---

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

---

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

2 Answers  

---

I have a scenario like Deptno=10---->First record and last record Deptno=20---->First record and last record Deptno=30---->First record and last record I want those first and last records from each department in a single target. How to do this in DataStage, any one can assist me. Thanks in advance.

8 Answers  

---

how can we join one oracle & flat files ?

2 Answers   ME,

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

0 Answers   Virtusa,

---