Answer Posted / bharath

Hi,
Join stage is best 4 full outer join bcoz
lookup is RAM intensive where as join uses less memory.

Differentiate between datastage and informatica?

1170

---

how to delete one row in target dataset

3100

---

In Informatica,for the table I can find coreesponding dependent mappings.Likewise can I find the dependent jobs with all the information by using the table name

2454

---

Demonstrate experience in maintaining quality process standards?

2524

---

Name the different types of Lookups in Datastage?

1245

---

what is the use of materialized view?

1553

---

Describe the main features of datastage?

1065

---

Source has 2 columns: USA,NewYork INDIA,MUMBAI INDIA,DELHI UDS,CHICAGO INDIA,PUNE i want data in target like below: INDIA,MUMBAI1 INDIA,DELHI2 INDIA,PUNE3 USA,NEWYORK1 USA,CHICAGO2

764

---

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

993

---

What is aggtorec restructure operator?

1427

---

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

1120

---

Can you explain repository tables in datastage?

1387

---

How will you load you daily/monthly jobs datas in to Fact and Dimension table using datastage.

3453

---

disign the complex job in u r project?(they are aksing only complex job design and then data flow...)

2441

---

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

3737

---