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

what is Partitioning ? where we can use Partition?

2 Answers   IBM, TCS,

---

I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me

6 Answers   Mastek,

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---

without matching columns in two tables. how can you join

5 Answers   BirlaSoft,

---

i have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

---

What are limitations of joiner transformation?

2 Answers   Exilant, TCS,

---

error reading data in flatfiles. Instead rading Ravi Teja its reading Ravi?Teja.How to handle this issue.

4 Answers  

---

what are the different types of transformation available in informatica. And what are the mostly used ones among them?

0 Answers  

---

Write the different tools in the workflow manager?

0 Answers  

---

tell me 7.x and 8.x diferrencess(but not transformations)

1 Answers  

---

Explain grouped cross tab?

1 Answers   Accenture,

---

How can you complete unrcoverable sessions?

1 Answers  

---