Answer Posted / ganga

HI Dharmendra,


here i want to pass the uniq records through filter is possible are not?

What is joiner transformation?

984

---

Whats there in global repository

1675

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1229

---

How to configure mapping in informatica?

1161

---

What is Index Caches size?

1094

---

To import the flat file definition into the designer where should the flat file be placed?

1043

---

What is meant by query override?

1043

---

What is expression transformation?

1085

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1116

---

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1105

---

How an expression transformation differs from aggregator transformation?

1024

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7421

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4132

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1070

---

What does command task mean?

1122

---