Answer Posted / sindhu

BY using sequential file in format delimeter =none while importing the data enable the option fixed width and give column width 5 space 5 space 5.datatype as varchar inorder to get zeros also in output.
reducing the stages will always increase performance

What are the types of views in datastage director?

1235

---

What is the importance of the exception activity in datastage?

614

---

What are stage variables and constants?

694

---

What is difference between server jobs & parallel jobs?

615

---

What is size of a transaction and an array means in a datastage?

727

---

---

What could be a data source system?

570

---

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.

3493

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2264

---

what are the devoleper roles in real time? plz tell i am new to datastage....

1630

---

What are the various kinds of the hash file?

652

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1114

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

2017

---

Define data aggregation?

658

---

What are the types of containers?

672

---

There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this

1796

---