Answer Posted / vali

you can use source qualifier transformation to do this.
write join condition ...
the rest of the operation will be same

Explain the different kinds of facts.

978

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

2069

---

Write the unconnected lookup syntax?

1080

---

Enlist the tasks for which source qualifier transformation is used.

1030

---

what are 3 tech challenges/ common issues you face?

2342

---

i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance

2123

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1244

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2177

---

How many dimensions are there in informatica?

1077

---

What are the designer tools for creating transformations?

1112

---

How to load data in informatica ?

1001

---

How do you load unique records into one target table and duplicate records into a different target table?

1239

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

2024

---

How many ways a relational source definition can be updated and what are they?

1013

---

What is domain in terms of informatica?

1003

---