What is the differentiate between data file and descriptor file?

0 Answers  

---

what is the use of surogate key in datastage

0 Answers   TCS,

---

How do you run datastage job from the command line?

0 Answers  

---

Define APT_CONFIG in Datastage?

0 Answers  

---

i have flat file and using unix how can i generate sequence number into targer?

1 Answers   Cap Gemini,

---

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

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  

---

what is the difference between lookup stage reject link and merge stage reject link in datastage Parallel jobs?

9 Answers   HCL,

---

What is meta stage?

0 Answers  

---

How the ipc stage work?

0 Answers  

---

What is Fastly Changing Dimension?

6 Answers   TCS,

---

Explain the importance of surrogate key in data warehousing?

0 Answers  

---