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

Explain the informatica workflow?

1120

---

how to create user defined function (udf) in informatica

1346

---

What are the new features of informatica 9.x developer?

1025

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

1330

---

Which files are created during the session rums by informatics server?

1229

---

What is pmcmd command?

1175

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1243

---

State the differences between sql override and lookup override?

1277

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1202

---

Explain the etl program with few examples.

1108

---

How an expression transformation differs from aggregator transformation?

1077

---

expain about the tune parameters?

2453

---

Explain joiner transformation in informatica

1169

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1552

---

What is mapplet in informatica?

1121

---