Answer Posted / krishna

1.two or more relational tables are with primary key-
foreign key relationships by linking the sources to one
Source Qualifier transformation.
2.the data types of the ports must match.

violation of these two conditions may lead to errors while
joining two tables

Enlist the differences between database and data warehouse.

1127

---

wat are deployement groups in informatica, how it will be used for developers

1720

---

Which version configuration tool used in ur project?

3262

---

What are connected or unconnected transformations?

1126

---

What are the different options available for update strategy?

1005

---

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.

1168

---

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

1729

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2038

---

 Informatica Checkpoints

3334

---

Reusable transformation and shortcut differences

1842

---

3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs

2252

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2009

---

How to update or delete the rows in a target, which do not have key fields?

1180

---

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

1090

---

What are the designer tools for creating transformations?

1119

---