when will you go for dataset and fileset?

2 Answers   Accenture,

---

Hi guys, Please design a job for dis requirement with derivation(solution). my source table like dis. emp_no qualification 1 a 1 c 2 a 3 c 3 b To loaded to target like dis emp_no qualification 1 b 2 b 2 c 3 a my requirement is every employer have three qualifications i.e a,b and c. what qualification missed in source table that will be move to target systems. Hope u got it the requirement. Right Thanks.

0 Answers  

---

Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC

0 Answers   CTS,

---

how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)

0 Answers  

---

In Datastage, how you can fix the truncated data error?

0 Answers  

---

---

What is the difference between informatica and datastage?

0 Answers  

---

pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?

1 Answers  

---

Differentiate between data file and descriptor file?

0 Answers  

---

which cache supports connected & un connected Lookup

1 Answers   Wipro,

---

1)How will u implement SCD2 by using surrogate key. 2)What are the disadvantages with surrogate key. 3)How will you handle nulls in your project for the varchar, integer data types. 4)Can I use two fact tables in star schema. 5)3 jobs are running on the 2 nodes after I added one more node so can I compile those jobs to run on three nodes.

0 Answers  

---

what r the stages mostly used in realtime scenarios

4 Answers   HCL, IBM,

---

What is the project in datastage?

0 Answers  

---