Answer / kiran

hai This is Kiran..,

Call routines in designer by using ytransformewr stage

Answer / subhash

double click on the transformer stage, right click on any
one of the mapping field select [dstoutines] option within
edit window give the business logic and select the either
of the options( Before / After Sub Routines.

Answer / abhi jain

There is a routine activity in job sequence through which
you can call your routine.

In merge stage can we update the values?

3 Answers   TCS,

---

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 is normalization and denormalization

2 Answers   CTS,

---

how to sort two columns in single job in datastage.

1 Answers   TCS,

---

what is factless fact table?

3 Answers   IBM,

---

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

0 Answers  

---

How one source columns or rows to be loaded in to two different tables?

0 Answers  

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

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,

---

Name the third party tools that can be used in datastage?

0 Answers  

---

what is the use of materialized view?

0 Answers   CTS,

---

HOW CAN WE SEE THE DATA IN DATASET?

12 Answers   IBM, TCS,

---