Answer Posted / venkateshmalneni

If the structure of the two flat files is same we can use SQ.by using in direct


if there is no common field in the two flat files then
create dummy columns in the exp t/r and then by using the dummy columns u can join them in the joiner t/r by giving the condition dummy = dummy1.
the flow is like this


src1--->SQ----->exp--->
|--->joiner---->target
src2--->SQ----->exp--->

how tokens will generate?

2249

---

Explain the pipeline partition with real time example?

1200

---

How can you define user defied event?

1075

---

What are the different types of transformation available in informatica.

1145

---

explain about unit testing? in real time?

2265

---

How to delete duplicate row using informatica?

1089

---

What are the differences between a connected lookup and unconnected lookup?

1125

---

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2510

---

EXL informatica Questions

1446

---

Explain sessions. Explain how batches are used to combine executions?

1080

---

design of staging area?

2075

---

How can we use batches?

1063

---

What are the informatica performance improvement tips

1151

---

What are the uses of etl tools?

1175

---

What are the differences between source qualifier and joiner transformation?

1137

---