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.

what is the unix script to run the job? Please mention commands which we use often?

3 Answers   TCS,

---

What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

Difference between the Sequence and Sequencer in DS?

1 Answers   TCS,

---

Can you explain kafka connector?

0 Answers  

---

WHAT ARE PERFORMANACE SETTINGS YOU HAVE IMPLEMENTES IN YOUR PROJECT?

2 Answers   GE,

---

Nls stands for what in datastage?

0 Answers  

---

how many types of remove the duplicate records?

3 Answers   Caterpillar,

---

what is the definitions for Datawarehose and Datamart?

4 Answers  

---

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

---

Is it possible to query a hash file?

0 Answers   IBM,

---

What are the features of datastage flow designer?

0 Answers  

---