Answer / d anil babu

hi this is anil.


seqfile---->transformer----->dataset

in transformer take constrain and in that ename=vijay and give
value 1 abort after rows in consrain window

Wat is pre-load in Hashed file

1 Answers   Patni,

---

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  

---

while we using change capture stage we have to be take two table thats are 1.before table 2. after table . what is before table and after table please give me clear notation Thank You very much in advance

2 Answers   MGL,

---

hi, how would i run job1 then job 3 , then job2 in a sequence of job1 ,job2,job3. Thanks sunitha

6 Answers   CTS,

---

how to export or import the jobs in .ISX file

0 Answers  

---

---

Difference between IBM DATA STAGE8.5 and DATA STAGE9.1 ?

0 Answers   ABC, TCS,

---

How to convert alpha Numeric values to alpha using functions?

1 Answers   CTS,

---

How do u view log file for a particular job?

6 Answers   HP,

---

what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,

---

What is the flow of loading data into fact & dimensional tables?

0 Answers  

---

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

---

How can we improve the performance in datastage?

0 Answers  

---