Answer / lakshmi

Working up with fact jobs is a complex one as to gather the source from multiple dimensions in to one dataset, while gathering it may endup with joining many lookups and db connectors.

What is the difference between lookup and sparse lookup?

1 Answers  

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

what is factless fact table?

3 Answers   IBM,

---

I have Seq file, I don't want 10, 11th(or any two records like 20, 30th records ) records in the output

6 Answers   TCS,

---

if a column contains data like ram,rakesh,madhan,suraj,pradeep,bhaskar then I want to place names separated by commas in another columns how can we do?

2 Answers   IBM,

---

what is hash file

2 Answers   CTS, IBM,

---

how to identifie,is it innerjoin,leftouter join in lookup?

2 Answers   Hexaware,

---

how to validate the jobs

2 Answers   IBM,

---

hi my source is:: empno,deptno,salary 1, 10, 3.5 2, 20, 8 2, 10, 4.5 1, 30, 5 3, 10, 6 3, 20, 4 1, 20, 9 then target should be in below form... empno,max(salary),min(salary),deptno 1, 9, 3.5, 20 2, 8, 4.5, 20 3, 6, 4, 10 can anyone give data flow in data stage for the above scenario.... thanks in advance...

5 Answers  

---

Hi, Please tell me how to solve this scenario in datastage ? Here we have 3 columns in a table TEST CODE,ENTRY DATE and BATCH The table looks like CODE ENTRYDATE BATCH 100 100716 1 100 100716 1 100 100716 1 200 122517 2 200 122517 2 302 555555 8 302 555555 8 302 555555 8 We need to create a seqno on grouping these 3 columns. The result should be like this. CODE ENTRYDATE BATCH SEQNO 100 100716 1 1 100 100716 1 2 100 100716 1 3 200 122517 2 1 200 122517 2 2 302 555555 8 1 302 555555 8 2 302 555555 8 3

1 Answers   Alpharithm Technologies,

---

How complex jobs are implemented in datstage to improve performance?

0 Answers  

---

Why do you need stage variables?

0 Answers  

---