Answer Posted / sarvesh

if it is flat file ur answer is write,if it is relational
souce then go to source qualifier properties there u write
the query like
select distinct a.* from t1 a where 10=(select sal from
t1 b where a.sal>b.sal)
i think it is working

How to load data in informatica ?

955

---

What are the different lookup cache(s)?

1036

---

can any one explain about dataflow in the informatica project for bank domain....thanks is advance

10633

---

How to do the error handling of if ur source is flatfiles?

1913

---

How union transformation is used?

959

---

What is decode in informatica?

1074

---

What is domain and gateway node?

1122

---

Define mapplet?

964

---

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

1007

---

what is mean by complex business rule ?

2110

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1899

---

Briefly explain the aggregator transformation?

943

---

What are roles and groups and benefits of using them?

992

---

What do you mean by channel change?

967

---

What is the way to execute pl/sql script using informatica mapping?

1510

---