Answer Posted / manikandan

The only difference that the inital load jobs were set to
first truncate the tables and then do a complete load and
the incremental load was set to insert new rows and update
existing rows for DIMENSION Tables. Facts jobs were same
(truncate and complete load)

Notification Activity

1350

---

Explain connectivity between datastage with datasources?

942

---

Explain ibm infosphere information server and highlight its main features?

1037

---

i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu

2676

---

Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...

4140

---

how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

754

---

What are the different layers in the information server architecture?

1079

---

Does datastage support slowly changing dimensions ?

1054

---

What is the purpose of interprocessor stage in server jobs?

2171

---

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?

2133

---

hi.... am facing typical problem in every interview " I need some critical scenarios faced in real time" plz help me guys

2822

---

Hi All , in PX Job I have passed 4 Parameters and when i run the same job in sequence i dont want to use those parameters , is this possible if yes then how

1508

---

Have you have ever worked in unix environment and why it is useful in datastage?

1085

---

how to abort the job its matain duplicates?

2534

---

What are the types of jobs we have in datastage?

1024

---