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--->

What is target load order?

1238

---

Explain the shared cache and re-cache?

1111

---

Can we create multiple integration service on single repository?

1185

---

How does a sorter cache works?

1063

---

Explain pushdown optimization $pushdownconfig parameter - informatica

1128

---

Write the program through which the records can be updated?

998

---

What are active transformations.

1649

---

Different sorts of metadata that stores in the storage facility?

1008

---

What is meant by query override?

1055

---

what are the Methods For Creating Reusable Transformations?

1166

---

How can you validate all mappings in the repository simultaneously?

1363

---

What is sorter transformation?

1041

---

define galaxy repository in informatica

2220

---

What are some examples of informatica etl programs?

930

---

What does role playing dimension mean?

1044

---