Answer Posted / pushparao

if there is no matching column two flat files, that means
two tables are different,no need to join the source
definitions in the designer.
there is possibility to join them.
create common columns in both expression transformations.
seqgen
|
sd-->sq-->expr
Joiner-->td
sd-->sq-->expr
|
seqgen

Explain the mapping variable usage example in informatica

1224

---

What are the different lookup cache(s)?

1167

---

Can we get 1st record through Informatica(without sequence number).

1519

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10321

---

What is repository manager?

1027

---

What is olap (on-line analytical processing?

1110

---

What is workflow manager?

1100

---

What's the layout of parameter file (what does a parameter file contain?)?

2437

---

What is joiner transformation in informatica?

1100

---

What is decode in static cache?

1262

---

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?

1145

---

What is meant by incremental aggregation?

1184

---

How do you handle two sessions in Informatica

1219

---

design of staging area?

2075

---

What is a node in Informatica?

1086

---