Answer Posted / gopal

In joiner we can join two heterogeneous sources for entire
records based on a condition.

But in look up only the first value or last value of the
records will be passed if more records matched with that
condition. So only one value will be returned to the
transformation.
EX:
in source : No Name
1 -
Look up table: No Name
1 A
1 B
1 C

Now we can return only A or C in look up.
If we need entire values we must go for joiner. Take that
look up table as source and use joiner. No alternative
solution.

how tokens will generate?

2156

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1845

---

How can we delete duplicate rows from flat files?

1165

---

Explain the shared cache and re-cache?

1051

---

explain about unit testing? in real time?

2140

---

What are multi-group transformations?

1013

---

Explain transaction control transformation in informatica

1213

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1876

---

How do you set a varible in incremental aggregation

1828

---

tell me about your project functionality

2295

---

permutations of mapplet

2456

---

How can we use mapping variables in informatica? Where do we use them?

1101

---

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?

1004

---

What is the procedure for creating independent data marts from informatica 7.1?

1002

---

without table how to come first record only in oracle?

2207

---