What is a merge in datastage?

0 Answers  

---

LIST THE BUILT-IN STAGES AVALIABLE IN SERVER JOBS?

2 Answers   Mannar Company, ME,

---

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  

---

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

0 Answers  

---

I have 2 Files like fileA fileB Output1 Output2 Output3 1 6 1 6 11 2 7 2 7 12 3 8 3 8 13 4 9 4 9 14 5 10 5 10 15 6 11 7 12 8 13 9 14 10 15 please let know

6 Answers  

---

when we have to go for a sequential file stage & for a dataset in datastage?

1 Answers  

---

Difference between JOIN,LOOKUP,MERGE?

2 Answers   CTS,

---

can we use sequential file as a lookup

7 Answers   Cognizant, Wipro,

---

What is data partitioning?

0 Answers  

---

what is meant by port ? what is the use of port ? what are the different type of ports and its usage

2 Answers   Accenture,

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs? interm of output in Merge Reject link and Look Up Reject link ?

4 Answers   HCL,

---

types of errors in datastage?

2 Answers   Reliance,

---