what is flow of project?

0 Answers   HSBC, IBM,

---

i have one table with one column in this column i have three rows like 1,1,2 then that rows populate to target as first tow rows as one row and remaing row as one row how it posible? COLUMN_NAME SHIVA RAMU MADHU THEN I WANT TO LIKE SHIVA AND RAMU IN ONE ROW AND MADHU IS ONE ROW IF ANY ONE KNOW PLZ TELL ME

3 Answers   Cap Gemini,

---

hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals

0 Answers  

---

what are fact tables and dimension tables? give example assuming one table.

3 Answers   IBM,

---

In which situations we can use normal and sparse lookup stages

4 Answers   IBM,

---

What is the function in Transformer stage can act as Rank Function in oracle

1 Answers   Reliance,

---

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  

---

Hi Gus, Can u pls tell me How can u Call the Shell Scripting/Unix Commands in Job Sequence?

3 Answers   IBM,

---

What is the differentiate between data file and descriptor file?

0 Answers  

---

Tell me Wt main advantage of Stage varibles? Project level hints?

4 Answers   Hexaware,

---

Why we use parameters instead of hard code in datastage.

2 Answers   IBM,

---

What is the sortmerge collector?

0 Answers  

---