Answer Posted / shalaka kulkarni

When work flow starts integration service retrieve mapping ,workflow ,and session form repository,It extract data from mapping sources and store in staging area apply transformation logic .then load it into target according to requirement. For that it uses three components:
Integration service process
Load balancer
DTM process

Parameter and variable differences

2021

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1116

---

Explain why we use partitioning the session in informatica?

1025

---

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2312

---

What is rank transformation in informatica

1120

---

What is the different lookup cache(s)?

1044

---

difference between informatica 8.1.1 and 8.6

3639

---

Scheduling properties,whats the default (sequential)

1904

---

How can we update a record in the target table without using update strategy?

1099

---

Explain lookup transformation in informatica

1021

---

What is the difference between stop and abort in informatica

1053

---

What is the need of an ETL tool?

1044

---

How do you set a varible in incremental aggregation

1831

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

8177

---

wf dont have integration severances how you can run?

1892

---