Answer Posted / sakthi

1.sq1 (query override gender='m') -> exp1 ,seq1 gen nextval to exp1

2.sq2 (query override gender='f') -> exp2 ,seq2 gen nextval to exp2

3. connnect o/p exp1 to exp2 to joiner
* condition nextvalue =nextvalue
* condition type full outer join

4. connect name from exp1 & name from exp2 to target

What all are steps in up gradation of Informatica server?

1093

---

What are pre and post-session shell commands?

1385

---

How we can create indexes after completing the load process?

1199

---

How does a sorter cache works?

1109

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

1227

---

Explain the difference between a data warehouse and a data mart?

1108

---

How does the aggregator transformation handle null values?

1192

---

How can you validate all mappings in the repository simultaneously?

1423

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2347

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4148

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1210

---

Differentiate between Load Manager and DTM?

2209

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2168

---

How many ways are there to create ports?

1401

---

What are the different lookup cache(s)?

1165

---