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 do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?

1 Answers  

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

Briefly define a session task?

0 Answers  

---

diffrence between command task and control task

1 Answers   iNautix,

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

---

How do you promote a non-reusable transformation to reusable transformation?

0 Answers   Informatica,

---

To achieve the session partition what r the necessary tasks u have to do?

1 Answers  

---

Which version configuration tool used in ur project?

0 Answers   CTS, TCS,

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

I've an excel sheet, in which one column contains data about the location like "City, State" and few columns contains only "State". Now I wanna load into my target City and State into two different columns. Pls help me out...

6 Answers   TCS,

---

When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?

5 Answers  

---