Answer / datastage4you

Use Pivot stage

Thanks
www.datagenx.net

in sequtial file 2 columns avaliable, i want only one column load the target. for this we can do by modify and copy stage. But here when using modify stage (in property drop column1) until it is ok. if target is data set How to view the data. with out using data management. what is the reason for this. if any body know this answer plz tel me. thanks.

1 Answers   IBM,

---

I am defining one varaible parameter date in job parameters.I want use this variable date in where clause in source query.

2 Answers   TCS,

---

1)what is the size of Fact table and dimension table? 2)how to find the size of Fact table and dimension table? 3)how to implement the surrogate key in transform stage? 4)write the configuration file path? 5)how many types of datasets explain? 6)diff b/w developed projects and migration projects? 7)how to delete the header and footer file of the sequencer file? 8)how can u call the parameters in DS in unix environment? 9) how much data ur getting daily ? 10)

0 Answers   Polaris,

---

How do you start developing a datastage project?

0 Answers  

---

How to convert table data into xml file using xml output stage? please explain step by step;

2 Answers   IBM,

---

HOW CAN WE SEE THE DATA IN DATASET?

4 Answers  

---

How a source file is populated?

0 Answers  

---

What is the difference between operational data stage (ods) and data warehouse?

0 Answers  

---

How to write a expression to display the first letter in Caps in each word using transformer stage ? Please let me know ASAP Thanks in advance...

0 Answers   Alpharithm Technologies,

---

What is configuration your file structure 2)I have two databases both are Oracle while loading data from source to target the job takes 30 min but I want to load less time how?

1 Answers   Hexaware,

---

Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?

3 Answers   IBM, TCS,

---

how can u find out the datastage job is running on how many nodes

7 Answers   IBM,

---