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

In any project how many mappings they will use(minimum)?

1 Answers  

---

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

how can u load the data in time dimension?

3 Answers  

---

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

---

What is the use of source qualifier?

0 Answers  

---

normalizer transformation

3 Answers   CTS,

---

wat transf shud i use to achieve this id sal id sal sum src-1 20 tgt 1 20 40 1 20 1 20 40 2 15 2 15 35 2 20 2 20 35

2 Answers  

---

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

---

What is the difference between sequential batch and concurrent batch and which is recommended and why?

1 Answers  

---

What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?

3 Answers  

---