Answer / sivaprasad

DimAgreementStatus,
DimCalendarDate
DimDBANAME
FACTMOPOLICYRELATIONPRO

Answer / dev

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

1. How many People are part of your Team? 2. Explain how you create jobs or flow of project? 3. Join Stage vs Lookup vs Merge Stage 4. Summation scenario based question - How you find sum of salary for a specific employee (Explain stages and flow of job)? 5. Explain Remove duplicates stage ? Can you do sort in this stage? 6. SQL Questions - Joins - Types, Difference between Join and Union 7. Unix Questions - How you run the Job, How you list all jobs in project 8. Explain Environmental Variables? 9. SQL Scenario - If you have 3 Identical record in a Table, Ex: 1, Ram, Xyz; 1, Ram, Xyz; 1, Ram, Xyz; Delete only 2 of the records and keep only 1 using the Delete query. How you will you do this?

1 Answers  

---

in sequtial file 2 columns avaliable,iwant only one column load the target how do it.

10 Answers   Wipro,

---

how many types of remove the duplicate records?

3 Answers   Caterpillar,

---

I have a source like file it have Number of records and i want to load without first and last records in target?Datastage?

4 Answers   CSC,

---

1)Source file contains one record, I want 100 records in target file.

3 Answers  

---

I HAVE EMP TABLE, 4 COLS R THERE COL1,COL2,COL3,COL4 ID-- 101,102,103,104 SAL-- 1000,4000,2000,5000 DATE-- COLUMN. I WANT TO DISPLAY THE DATA PREVIOUS MONTH HIGEST SAL ?

2 Answers   Wipro,

---

Define repository tables in datastage?

0 Answers  

---

Can you explain how could anyone drop the index before loading the data in target in datastage?

0 Answers  

---

table a contains 5 columns and table b contains 5 columns how can i get 10 columns at target?

9 Answers  

---

explain unit testing,systemtesting,integrated testing

1 Answers   CSC,

---

How many number of reject links merge stage can have?

7 Answers   TCS,

---

options available in sequence job to run,validate?

0 Answers   CTS,

---