Answer / rajesh.dwh

Function must returns value, but Procedure may or may not
return value.
Function can be use with select statement where Procedure
can't be used with select statement regarding ORACLE SELECT
statement.

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

0 Answers  

---

i have 4 jobs i want run 1job should run on 1node and 2job runon 2node and.... how to make it possible?

1 Answers  

---

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

---

how will u design file watch jobs?

2 Answers  

---

in one scenario source flat file like Fileld1 00122001550056200568 00256002360014500896 00123004560078900258 00147004560025800256 divide each 5 numbers as one column i.e here i need field1 field2 field3 field4 00122 00155 00562 00568 00256 00236 00145 00896 00123 00456 00789 00258 00147 00456 00258 00256 plz help me....

4 Answers  

---

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

What is datastage engine?

0 Answers  

---

What is size of a transaction and an array means in a datastage?

0 Answers  

---

How do you load dimension data and fact data? Which is first

2 Answers  

---

plz tell me some dimentional and fact table names in banking project?

2 Answers   Virtusa,

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

what is the use of surogate key in datastage

0 Answers   TCS,

---