Answer Posted / amit

read the file from sequential file stage, use a transformer in between, write the same data to the same file using sequential file stage as target by setting option to - load file in append mode.

In a batch if a job fails in between and you want to restart the batch from that particular job and not from the scratch then what will you do?

607

---

What are routines in datastage? Enlist various types of routines.

631

---

how to run a sequential file stage in parallel if the stage is used on the TARGET side

1145

---

What is the purpose of interprocessor stage in server jobs?

1731

---

Is the value of staging variable stored temporarily or permanently?

585

---

---

Can you filter data in hashed file?

3354

---

Where do you see different stages in the designer?

637

---

Describe the architecture of datastage?

575

---

What are the primary usages of datastage tool?

628

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2017

---

Does datastage support slowly changing dimensions ?

663

---

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.

3508

---

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

1647

---

How to RD using transformer?

868

---

Nls stands for what in datastage?

730

---