Answer / Pankaj Kumar Sinha

Join, Merge, and Lookup are data integration stages in DataStage. They perform different operations:
1. Join: Combines records from two or more data sources based on a common key.
2. Merge: Compares and merges records from multiple sources that match on a common key. It's useful when handling late-arriving data or dealing with inconsistent timestamps.
3. Lookup: Retrieves values from a reference table for each record in the main stream based on a matching key.

How many types of sorting methods are available in datastage?

1 Answers  

---

what is the new version in Datastage ? what is the diff b/t New vesion & 7.5 version?

12 Answers   Wipro,

---

With out using Funnel Stage, how to populate the data from different sources to single target

12 Answers   Wipro,

---

How to manage date conversion in Datastage?

1 Answers  

---

how to handle null values in sequential file?

1 Answers   HCL,

---

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

1 Answers   Virtusa,

---

How to create a doccument in datastage?

1 Answers   Cap Gemini,

---

1.When did 8.1 parallel came into existence? 2.What is the difference between 7.5 and 8.1?

2 Answers   Mind Tree,

---

Distinguish between informatica & datastage. Which one would you choose and why?

1 Answers  

---

tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

1 Answers   IBM,

---

diff between OLTP and OLAP? what TOP-DOWN and BOTTOM-UP Approach? which is best? what are Star Schema and Snow Flake Schema?

2 Answers   TCS,

---

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.

1 Answers  

---