Answer / ramesh

any number of columns we can perform aggregation
ex:group by deptno,group by deptname,

Answer / devendra singh

any no of columns we can aggregate in aggregation stage

Answer / kiran

Depends upon Requirement....u can apply aggregations

Is there any possibility to generate alphanumeric surrogate key?

3 Answers   ABC, IBM,

---

what are the types of nodes

4 Answers   HCL, TCS,

---

How do u convert the columns to rows in datastage?

0 Answers  

---

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,

---

Pls tell me what is troubleshooting in datastage view?

1 Answers  

---

1.What is the flow of Transformer? 2.How can you do INDEX table in DataStage level?

0 Answers   EDS,

---

How to RD using transformer?

0 Answers   CTS,

---

What is the Main difference between Lookup Failure and Lookup Not Met? Plz explain with Example.

2 Answers  

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

0 Answers   TCS,

---

What are the unit test cases you used in your project?

1 Answers   CSC, HY,

---

Differentiate between datastage and informatica?

0 Answers  

---

file1 1 2 3 4 file2 3 4 5 6 output should be in three targets T1 T2 T3 1 3 5 2 4 6 how to do this? can any one help? Thanks

5 Answers   Cap Gemini,

---