Answer / mallika

Sequential file stage doesn't recognize nulls. So in format
tab you will find an option null to value property and there
you can enter any value

what is normalization and denormalization

2 Answers   CTS,

---

what is a message handler

3 Answers   IBM,

---

how to convert rows into columns

2 Answers   IBM,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?

15 Answers   Scope International,

---

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

---

job locking methods? How can we unlock the job?

3 Answers   IBM,

---

Can aggregator and transformer stages use to sort the data? How ?

2 Answers  

---

I have oracle enterpaise stage, oracle bulkloader stage, ODBC stage and I want to load data in to target, which of the above stages do I need to use and why?

3 Answers   Virtusa,

---

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  

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

How many types of views are there in a datastage director?

0 Answers  

---