Answer Posted / sabyasachi

Parallei Query: To execute a query with the help of muliple
servers.
QueryHints: This are compiler directives to execute any
particular SQL query.This is generally done to override the
default mode in which the compiler is going to execute the
query.

While migrating the data from one environment to another environment how would you manage the connections?

1078

---

Differentiate between a repository server and a powerhouse?

1114

---

What do you understand by a term domain?

1120

---

Why is sorter an active transformation?

1115

---

what is the size of your data warehousing?

2091

---

What do you mean by filter transformation?

946

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

1089

---

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?

1504

---

What is a sequence generator transformation?

1010

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2552

---

Please let me know how to make Data masking in informatica..

1703

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1119

---

Differentiate between Load Manager and DTM?

2150

---

What is joiner transformation?

1004

---

What are the mapping parameters and mapping variables?

1186

---