Answer / kiran

1)totally how many jobs created in ur project?
Ans:Depend upon duration: suppose u mentioned as like 12-15
months:52 jobs
2)what is ur datamart size & Dwh size
Ans: no one know about size of the DWH but u can define as
like it should be tera bites and datamart size is 6 gb
3)How secure ur project
Ans:take care under Admin
4)could u plz tell be about testing process after complete
the job will run sucessfully or not in Datastage

What is diff between Junk dimensions and conform dimension?

4 Answers   Polaris,

---

I have source file which contains duplicate data,my requirement is unique data should pass to one file and duplicate data should pass another file how?

7 Answers   CTS,

---

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  

---

what is Audit table?Have u use audit table in ur project?

3 Answers   Accenture, Wipro,

---

what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,

---

---

what is repositery?

0 Answers   IBM,

---

Difference between sequential file and data set?

0 Answers  

---

Hi am sundar, i have datas like 00023-1010 00086-1010 00184F2-1010 . . . . SCH-AS-1010 200-0196-039 . . . Now i want the result as values before the delimiter should come under the column ITEM_CODE and values after the delimiter should come under the column LOC_CODE.. But some datas like "SCH-AS-1010", for this, "SCHAS" should come under the column ITEM_CODE and 1010 should come under the column LOC_CODE.. Pls help me..

1 Answers  

---

A signal has a wavelength of 1 micro min in air.how far can the front of the wave travel during 1000periods?

0 Answers  

---

In one project how many shared containers are created?

3 Answers   NTT Data,

---

Hi guys, please design job for this, MY INPUT IS COMPANY,LOCATION IBM,CHENNAI IBM,HYDRABAD IBM,PUNE IBM,BANGLOORE TCS,CHENNAI TCS,MUMBAI TCS,BANGLOORE WIPRO,HYDRABAD WIPRO,CHENNAI HSBC,PUNE MY OUTPUT IS COMPANY,LOCATION,COUNT IBM,chennai,hydrabad,pune,banglore,4 TCS,chennai,mumbai,bangloore,3 WIPRO,hydrabad,chennai,2 HSBC,pune,1 Thanks

3 Answers   IBM,

---

What are the difference types of stages?

0 Answers  

---