Main Function of the Staging area in DWH ?

2 Answers  

---

Hi This is Vijay How Can u Read the data from sequential file Parall'y?

5 Answers   Semantic Space,

---

Can you explain kafka connector?

0 Answers  

---

Drop duplicate records ... SOURCE LIKE .......... ID flag1 flag2 100 N Y 100 N N 100 Y N 101 Y Y 101 N Y 102 Y N 103 N N 104 Y Y 105 N N 106 N Y 102 N Y 105 Y Y in above file if any id having both the flags as "N" then that corresponding id records should be dropped, in above case o/p should be as ID flag1 flag2 101 Y Y 101 N Y 102 Y N 102 N Y 104 Y Y 106 N Y Steps to do : 1) Identified the id’s that got duplicated (both the flag values having vales “N”) 2) Look up with these id’s to existing id’s to drop .

2 Answers  

---

how to configure databases through datastage

2 Answers  

---

what is the diff b/w switch and filter stage in datastage

2 Answers   Cap Gemini,

---

Difference between data warehousing and olap?

0 Answers  

---

How to read the length of word in unix?

0 Answers   CTS,

---

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,

---

If you want to use a same piece of code in different jobs, how will you achieve this?

0 Answers  

---

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

1 Answers  

---

what is usage of datastage with materialized views

4 Answers   HP, TCS,

---