Answer / bharath

Datastage is an etl tool, enable organizations to extract the information from multiple sources, Transform in the way that make it more valuable and delvers the data into target databases or any applications..

Answer / srinivas

Datastage is a Client and server Technology using this we
can design the jobs,run the jobs and monitering the jobs

Please explain me the difference between 3 types of slowly changing dimension in datawarehousing?

3 Answers   TCS,

---

What is the difference between datastage and informatica?

0 Answers  

---

can any 1 put a difference between datastage 7.5 and 8.0 all concepts plz r mail 2 me anu4u09@gmail.com

4 Answers   IBM,

---

Have you used Unstructured data?

0 Answers   CTS,

---

What is PX?

2 Answers   IBM,

---

How to convert RGB Value to Hexadecimal values in datastage?

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  

---

1.How to read multiple file from sequential stage. 2.If a file doesn't arrive or doesn't exists in sequential stage how do u handle this. 3.What do you do before taking data from source to staging area. 4. I have a remove duplicate stage and transformer stage.what will u do for optimizeing the performance of the job.

4 Answers   Syntel,

---

what is hash file

2 Answers   CTS, IBM,

---

What are the functionalities of link partitioner?

0 Answers  

---

1.How do u handle NULL in sequential stage. 2.Difference between switch stage and filter stage.

4 Answers  

---

wt is the difference between swith and filter stage

6 Answers   IBM,

---