Answer / Pankaj Shama

The TagBatch Restructure Operator in DataStage is used to change the order of fields within a record, add or remove fields, and apply various transformations. It's useful for restructuring the data format without needing to split and join operations.

Explain usage analysis in datastage?

1 Answers  

---

Hi friends,Two input files, wants to validate only if the reference data has '0' otherwise no validation should be done..how to do this??

1 Answers   IBM,

---

how can i abort the job if i get more than 100 errors in job log?

6 Answers   Accenture,

---

What steps should be taken to improve Datastage jobs?

1 Answers  

---

Can anybody tell me in detail any complex datastage job? I have worked only in direct load and full refresh jobs.But in all interviews this question arises

1 Answers   TCS,

---

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

2 Answers   IBM,

---

what should be ensure to run the sequence job so that if its get aborted in 10th job before 9job should get succeeded?

1 Answers   CTS,

---

How will you move hashed file from one location to another location?

1 Answers   NTT Data,

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

A flatfile contains 200 records.I want to load first 50 records at first time running the job,second 50 records at second time running and so on,how u can develop the job?pls give the steps?

3 Answers   TCS,

---

how to retrive the max(sal),deptno,empno in datastage?

13 Answers   Polaris,

---

what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none

1 Answers   Wipro,

---