Answer / Satish Kumar Meena

Critical scenarios faced in real-life situations can vary greatly depending on the job role and industry. Here are some examples that may be relevant for a data stage professional:n
1. Data corruption or loss: Unexpected data corruption or loss can occur due to hardware failures, software bugs, human error, or natural disasters. The data stage professional must have a plan in place to prevent data loss and to recover the corrupted data.
2. Data security breaches: Unauthorized access to sensitive data is a significant concern for any organization. The data stage professional must implement proper security measures to protect the data from unauthorized access and ensure compliance with relevant regulations.
3. Compliance issues: Meeting regulatory requirements can be challenging, especially when dealing with large amounts of data. The data stage professional must understand the relevant laws and regulations and ensure that the organization's data practices are compliant.
4. Data privacy concerns: Protecting user privacy is essential in today's digital age. The data stage professional must have a plan in place to anonymize data, obtain informed consent for data collection, and protect personal information from unauthorized access.

This is UNIX question asked in DataStage Interview. Say I have n numbers of records in a text file. I want first 3 records in 1st file, last three records in 3rd file and remaining n-6 records in 2nd file. (Note: we don't know how many records are there in the File. I am getting one file on daily basis and I want three target files as asked above)

2 Answers   CTS,

---

how to cleansing data

6 Answers   Cap Gemini,

---

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,

---

Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,

---

in datastage interview qustion source target ------- ------- 12345 1 2 3 4 5

3 Answers   IBM, YCS,

---

What are constraints and derivations?

1 Answers  

---

How can we run same job in 1 day 2 times

7 Answers   IBM,

---

How do you load dimension data and fact data? Which is first

2 Answers  

---

Two source files contains same meta data third file contains different data types can I funnel that file.

2 Answers  

---

in aggregator , how can i get the sum in readable format

4 Answers   IBM,

---

how to abort the job its matain duplicates?

1 Answers   TCS,

---

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based on cid which country's having more than 25 states i want to display?

3 Answers   Wipro,

---