Answer Posted / vemuri vijay

steps
go to
1.source anlyzer
import from files
then attach your
file
then
select tick the option
import field names from first line

difference between repository database and repository service?

1152

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2131

---

Which transformation should we use to normalise the COBOL and relational sources?

1213

---

What all join we can perform in LOOKUP transformation?

978

---

Explain what are the different types of transformation available in informatica.

1150

---

What is decode in static cache?

1180

---

Describe the impact of several join conditions and join order in a joiner transformation?

1063

---

How to implement security measures using repository manager?

1178

---

How might one distinguish in the case of mapping is right or not without associating session?

1123

---

without table how to come first record only in oracle?

2255

---

What do you mean by blocking transformation?

1041

---

What is blocking transformation?

1144

---

What are the types of schemas we have in data warehouse and what are the difference between them?

942

---

Explain about cumulative Sum or moving sum?

1043

---

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?

1100

---