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 mean by throghput? in informatica

3 Answers   Cap Gemini,

---

What are junk dimensions?

0 Answers  

---

HOw can we load the normalised data ( Vertical data) to (Horizontal data)with out using decode in the expression transformation and the aggregator transformation. But, what exactly I want is .. If we have million of records,it is not possible using decode and search for that Particular Id to pivot into Horizontal data... Can any one of guys please help me in this regard.....

3 Answers   TCS,

---

How i can upload the MainFrame source For Informatica ?

1 Answers  

---

If you done any modifications for a table in back end does it reflect in informatca warehouse or maping?

2 Answers  

---

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers   CTS,

---

Hi, This is Lakshmi,Anyone taking classes for datawarehouse-Informatica and BO with real time project

2 Answers  

---

what is fact table?

9 Answers  

---

What is the difference between a connected look up and unconnected lookup?

0 Answers  

---

Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,

---

what happens when a batch fails?

3 Answers  

---

What is meant by active and passive transformation?

0 Answers  

---