Answer / kathyayini

Test cases will prepare based on the requirement of the job
or project...

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 guys, In sequencer job, we have 3 sources, in that 1st source have some records, Here requirement is 1st source records are 100 then only run the job otherwise total job will abort... How to calculate this. please design the job. Thanks.

1 Answers   IBM,

---

can we half project in parallel jobs and half project in server jobs?

4 Answers   Infosys, L&T,

---

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

3 Answers   IBM,

---

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

0 Answers   Syntel,

---

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

0 Answers   Virtusa,

---

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

What is a quality stage?

1 Answers  

---

I WANT TO SEND SYSDATE AS PARAMETER,SO WHAT COMMAND I SHOULD USE TO CALL SYSDATE?

4 Answers   ME,

---

I have 100 records how can I load at a time from the single time

1 Answers  

---

I am getting input value like X = Iconv(“31 DEC 1967”,”D”)? What is the X value? How it is? At what situation we r used Iconv(),Oconv().

1 Answers   Amdocs, TCS,

---

tell me abt Datastage trigger?

1 Answers   HP, IBM,

---