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.

Why do we use link partitioner and link collector in datastage?

0 Answers  

---

can explain wt is the pool for file.

1 Answers   CTS,

---

1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

0 Answers   Wipro,

---

how will u design file watch jobs?

2 Answers  

---

How rejected rows are managed in datastage?

0 Answers  

---

What is meta stage?

0 Answers  

---

my source is sequencial file and my target is dataset. i am running the job in two node configuration file. my source having 10 records how the data move to target?

3 Answers   TCS,

---

Can you explain tagbatch restructure operator?

0 Answers  

---

how can or from where we can get reference data in scd type2 implementation?

2 Answers   JPMorgan Chase,

---

Explain the scenarios where sequential file stage runs in parallel?

3 Answers   Accenture,

---

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  

---

CAN WE DECLARE DATASET SET WITH OTHER THAN .DS EXTENTION OR NOT IF YES WHAT IS THE DIFFERENCE U FIND?IF NOT WHY?

2 Answers  

---