Answer / Kishor Kumarmishra

A Project in DataStage is a container for organizing related ETL jobs, operators, and metadata. It provides a logical grouping of objects and enables easy management and deployment of DataStage applications.

I have 2 files 1st contains duplicate records only, 2nd file contains Unique records.EX: File1: 1 subhash 10000 1 subhash 10000 2 raju 20000 2 raju 20000 3 chandra 30000 3 chandra 30000 File2: 1 subhash 10000 5 pawan 15000 7 reddy 25000 3 chandra 30000 Output file:-- capture all the duplicates in both file with count. 1 subhash 10000 3 1 subhash 10000 3 1 subhash 10000 3 2 raju 20000 2 2 raju 20000 2 3 chandra 30000 3 3 chandra 30000 3 3 chandra 30000 3

2 Answers   TCS,

---

What are the some differences between 7.x and 8.x version of datastage?

1 Answers  

---

How many Nodes configuration file you used in your last project?

1 Answers  

---

1)i put Pharma Project in my Resume..whar are the sources used in my project Generally? 2)how many fact and dimensional tables used? 3)Have u used any Datamarts and measues in fact table? ....plz give the answers...

2 Answers   iGate,

---

Why we use surrogate key?

1 Answers  

---

what is factless fact table?

3 Answers   IBM,

---

source file is having 5 records while moving into target it want to be 10 records

4 Answers   IBM,

---

How do you start developing a datastage project?

1 Answers  

---

What is the difference between validated and compiled in the datastage?

1 Answers  

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

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

1 Answers  

---