Answer / bharath

Instead of transformation use Combination in datastage,

Horizontal combining:
> join
> look-up
> merge
Vertical combining:
> remove duplicates
> Aggregation
Diagonal Combining:(not sure)
> vertical pivoting
> Horizontal Pivoting

Answer / npr

IS it DWH question ???????

insequential file 2header avaliable,and 100 records avaliable.how to skip the 2 headers and load 100 records target?

5 Answers  

---

What are the types of views in datastage director?

0 Answers  

---

Lookup constraints

0 Answers   CTS,

---

EXPLAIN SCD

0 Answers   CTS,

---

hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column"  hi everbody, i have a problem in my project.. Native Error Code: -407 "Assignment of a null value to a not null column" i have no idea, what should i do..please help :(

3 Answers  

---

how to get the unique records on multiple columns by using sequential file stage only

3 Answers  

---

Can you explain engine tier in information server?

0 Answers  

---

How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?

2 Answers   Wipro,

---

What is the sortmerge collector?

0 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,

---

WHAT are unix quentios in datastage

2 Answers   TCS,

---

how to create document in datastage?

1 Answers   Cap Gemini,

---