Answer / srinivasulu raju

It is a Process of Defining the User Defined SQL Query: "to
filter the data,Join the Data, Sorting the data,
eliminating Duplicates...

Condition: Source must be DataBase.

Answer / rams

yes

What is standalone command task?

0 Answers  

---

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

what is the flat file partition and where have to specify it

1 Answers   TCS,

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

1 Answers   IBM,

---

what is inline view?

1 Answers   IBM,

---

To provide support for Mainframes source data,which files r used as a COBOL files

1 Answers  

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

What is staging area?

11 Answers  

---

Where we use dynamic lookup and where we use it?do we generate surrogate keys using dynamic lookup?can we use it for scd type 2 mapping and why?

3 Answers   Amdocs,

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

Is snow flake or star schema used? If star schema means why?

4 Answers   CTS, Sonata,

---

In how many ways we can create ports?

0 Answers  

---