Answer / sivaprasad

DimAgreementStatus,
DimCalendarDate
DimDBANAME
FACTMOPOLICYRELATIONPRO

Answer / dev

dim- ACCOUNT ,BRANCH,CALENDAR,FOUND TRANS
FACT- DetailsFact,DAILYAGGREATFACT

how to do pergformence tuning in datastage?

4 Answers   MCA, Symphony, TCS,

---

How can u execute the sql query through unix? What is the Primary key for Dimension table? what is the primary key for Fact table?

5 Answers   TCS,

---

how many stages are there in Datastage... Please clarify mee??

3 Answers  

---

What is the method of removing duplicates, without the remove duplicate stage?

0 Answers  

---

Difference in the implementation of lookup and join stages,in joining two tables?

7 Answers   TCS,

---

---

Have you used Unstructured data?

0 Answers   CTS,

---

hi All, i have one scenario like if source--->transformer-->2 target sequential files the 1 st target sequential file is loads the data from source and 2nd target sequntial file contain the 1st target total record count,and file name of 1 st target seq file and timestamp seperated by delimeter for example if source have 10 record the 1st target seq file hav 10 records and 2nd target seq file example 10|xyz.txt|20101110 00:00:00 could you please help me out how can i implement in datastage job.

4 Answers   IBM,

---

where we use column generator stage in real time scenario?

5 Answers   TCS,

---

Explain how a source file is populated?

0 Answers  

---

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?

5 Answers  

---

what is parameterset?

4 Answers   Wipro,

---

I have 3 jobs A,B and C , which are dependent each other. I want to run A & C jobs daily and B job run only on sunday. how can we do it?

1 Answers   CGI,

---