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

How to use procedural logic inside infromatica?

1132

---

what is SDLC way of code development?

1966

---

What are the databases that informatica can connect to windows?

998

---

What is session task and command task?

1171

---

What is enterprise data warehousing?

982

---

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

1047

---

Briefly describe lookup transformation?

982

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1555

---

What is substr in informatica?

1131

---

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

988

---

How to join three sources using joiner? Explain though mapping flow.

1086

---

Define mapping and session?

966

---

What is a connected transformation?

1042

---

Parameter and variable differences

2002

---

What are the components of workflow manager?

1015

---