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 are indexes created after completing the load process?

1549

---

Can we create a Integration service without a Repository service and vice versa?

1174

---

what is index?how it can work in informatica

1982

---

Explain the difference between mapping parameter and mapping variable?

982

---

in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1987

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1011

---

What will be the approach?

930

---

what is degenerated dimension?

3873

---

What is option by which we can run all the sessions in a batch simultaneously?

1082

---

Why do we need informatica?

928

---

What is meant by incremental aggregation?

1026

---

What are the types of caches in lookup?

978

---

Explain how many types of dimensions are available in informatica?

1010

---

generate date / time dimension in informatica

1073

---

What is a sequence generator transformation?

954

---