Answer Posted / shar

When
col is converted from not null to null and data coming has
null or not null values then NO Problem.

But col is NULL constraint and converted to Not NULL then
two cases
i) when data coming from source has no NULL values then no
problem.
ii)when data coming from source has NULL values then the job
simply ABORTS.

i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS

3698

---

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

952

---

What is meta stage?

1131

---

Explain connectivity between datastage with datasources?

938

---

Distinguish between informatica & datastage. Which one would you choose and why?

952

---

if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?

2131

---

Does datastage support slowly changing dimensions ?

1053

---

How do you import and export the datastage jobs?

1109

---

Where the datastage stored his repository?

1018

---

what is flow of project?

1932

---

Name the different sorting methods in datastage.

989

---

State the difference between an operational datastage and a data warehouse?

1056

---

What is the difference between datastage and informatica?

1059

---

If we take 2 tables(like emp and dept),we use join stage and how to improve the performance?

2002

---

What is difference between server jobs & parallel jobs?

986

---