Answer / chandu

audit table is nothing but when the job is developed,how many no of stages are used,each stage having how many no of input records are there also how many no of out put records are there,job start date,job end date etc these information having audit table

I have load a Dataset in UAT with 2 Node configuration, imported the job into PROD environment which is 4 node configuration and using this DataSet as SRC to other job. will the job run fine or give any errors? If job runs fine, on how many nodes? 2 nodes or 4 nodes?

2 Answers   TCS,

---

How do y read Sequential file from job control?

2 Answers   HP, IBM, Telesis,

---

what is data mapping

2 Answers  

---

what is the use of materialized view?

0 Answers   CTS,

---

How can we do null handling in sequential files?

3 Answers   Reliance,

---

data stores in which location while using data set stage as the target?

1 Answers   IBM, TCS,

---

how to find out number of records imported into source file?

1 Answers  

---

how can we generate row values like 1 1 1 2 2 2 3 3 3 using col generator plz let me know

2 Answers  

---

I am having the 2 source files A and B and I want to get the output as, the data which is in file A and which doesn't in file B to a target 1 and which is in file B and which doesn't in file A to a target 2?

3 Answers  

---

Converting Vertical PIVOTing without using PIVOT stage in DataStage. Ex: DEPT_NO EMPNAME 10 Subhash 10 Suresh 10 sravs Output: DEPT_NO EMP1 EMP2 EMP3 10 subhash suresh sravs 2) How to implement Horizontal PIVOTing without using PIVOT stage.

3 Answers   Cognizant, UHG,

---

What are the partition techniques available in your last project?

1 Answers  

---

How do u convert the columns to rows in datastage?

0 Answers  

---