Answer Posted / rao

What will happen when Mapping variable and Mapping parameter
is not defined or given?
Where do you use mapping variable and mapping parameter?

If not declared in Parameter file, power center server will
try to fetch the value from initial value. If not then from
the default value.

What could be the possible resons of locks by user?

1087

---

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

1059

---

If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?

1483

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2069

---

What do you understand by term role-playing dimension?

1042

---

Differences between connected and unconnected lookup?

1211

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1090

---

What are data-driven sessions?

1192

---

How to generate sequence numbers?

1082

---

Scheduling properties,whats the default (sequential)

1945

---

Explain incremental aggregation in informatica

1117

---

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.

1160

---

Separate from an archive server and a powerhouse?

955

---

How do you manage the Parameter files while migrating your data from one environment to another environment?

1009

---

Explain the difference between a data warehouse and a data mart?

1056

---