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

What is informatica etl tool?

1059

---

Define mapplet?

1059

---

What do you mean by channel change?

1107

---

What is the difference between informatics 7x and 8x and what is latest version?

1137

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7498

---

How to update or delete the rows in a target, which do not have key fields?

1222

---

In warehouses how many schemas are there?

1128

---

What is the difference between stop and abort in informatica

1142

---

What are the types of presistent cache in look up tr.

2104

---

Is stop and abort are same in informatica?

1048

---

How to update source definition?

1141

---

How do you load only null records into target? Explain through mapping flow.

2075

---

How can a transformation be made reusable?

1232

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10321

---

What is a dimensional model?

1033

---