Answer / 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--->

Answer / gangam rajesh

using joiner transformation

Answer / mehul thakur

Hi Rajesh
could you plz tell me the steps to join from joiner tr.

Regards
Mehul Thakur

Write the advantages of partitioning a session?

0 Answers  

---

Explain how many types of dimensions are available in informatica?

0 Answers  

---

difference between informatica 8.1.1 and 8.6? And different betweeninformatica 7x and 8x?

1 Answers   HTC, TCS,

---

How to update source definition?

0 Answers  

---

How many ways you create ports?

1 Answers  

---

---

how to move the mappings from your local machine to claint place?

2 Answers  

---

Why should we use star schema in datawarehouse design?

2 Answers   Wipro,

---

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

---

What is sequence generator transformation in informatica?

0 Answers  

---

performance tuning of Informatica

1 Answers  

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

---

How will you check the bottle necks in informatica? From where do you start checking?

3 Answers   HCL,

---