Answer / subhash

1. SRC---->TFM---->TGT1,TGT2,TGT#
If source is seq file add the ROW NUM column also.
If source is Oracle select ROWNUM column also.
then our input look like this:
C1 1
C2 2
C3 3
c4 4
c5 5
c6 6
c7 7

in TFM,
put below condition for each target link.
TGT1--->MOD(ROWNUM,3)=1
TGT2--->MOD(ROWNUM,3)=2
TGT3--->MOD(ROWNUM,3)=0

Explain the situation where you have applied SCD in your project?

0 Answers  

---

what is initial load and incremental load

3 Answers   ADP,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

What are the main features of datastage?

0 Answers  

---

what is the main differences between Lookup, Join and Merge stages?

9 Answers   HCL,

---

Describe routines in datastage? Enlist various types of routines.

0 Answers  

---

how do u convert date in 20-12-07 to dec-20-2007 or 20-dec- 2007 or 20-dec-07 in parallel

3 Answers   Wipro,

---

WHAT ARE THE COMMON ERRORS IN DATA STAGE?

6 Answers   IBM, ME,

---

Explaine the implimentation of scd's in ds indetail, please send me step by step procedure to perform scd's 1,2,3. Please replay for this, Thanks in advance

0 Answers  

---

what is .dsx files

3 Answers   IBM,

---

Differentiate between data file and descriptor file?

0 Answers  

---