Hi any one has datasatge 8.5 certication dump could you please provide your details i will contact you. send reply to my mail rajaadivi@gmail.com Thanks in Advance

2 Answers  

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

i have seq file that contents 10 million records load to target any data base.. in that case it takes lot of time for loading..how do performance tuning in that situation...?

5 Answers   TCS,

---

How many areas for files does datastage have?

0 Answers  

---

how to connect source to db?generally what r stages u used? how to find the data is having delimiter format?

0 Answers   Wipro,

---

In my project source data comes from MAINFRAME in files.so,This time data is coming as a binary file...I know for binary data we use Complex flat file stage..I have used it also..but on 'view data' data is not coming correctly..as it in MAINFRAME.give me some ideas..

2 Answers  

---

How to enter a log in auditing table whenever a job get finished?

2 Answers   L&T,

---

Display all files which have size more 3KB in given directory/folder.

1 Answers   TCS,

---

What is the difference between the local container and shared container?

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 set mapping in datastage??

2 Answers   ADP,

---

what are the types of nodes

4 Answers   HCL, TCS,

---