Answer / todearhari

you can Use cat -n flatFile>Target to Generate line numbers.

I have a few records all are same structures data, I want to store data in multiple targets how?

4 Answers   Polaris,

---

I have a few records just I want to store data in to targets cycling way how?

0 Answers   Polaris,

---

How to lode data in sequntional files perform faster?

1 Answers   Polaris,

---

Name the third party tools that can be used in datastage?

0 Answers  

---

What are transforms and what is the differenece between routines and transforms?

0 Answers  

---

---

how to call sequential generator in datastage?

1 Answers   IBM,

---

How can i approach to write datastage 7.5 Certification? and how much they will charge for examination .What exactly should i do? Can anyone guide me plz?

2 Answers  

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

0 Answers  

---

What is PX?

2 Answers   IBM,

---

I have a few records just I want to store each records tow times in target how?

2 Answers   Polaris,

---

How to generate surrogate key without using surrogate key stage?

6 Answers   IBM,

---

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  

---