Answer Posted / krishna

Mapping
source - SQ -> Exp T/r -> Filter -> target

Exp t/r:
create 4 variable and 3 output ports.
v_curr,v_flag,o_filter,o_flag,v_count,v_prev,0_count

v_flag = iif(v_currnt = '*' OR v_prev = '*' or flag_v=1,
1,0)
v_count = iif(v_prev='*',count+1,count)
o_filter = iif(No!= '*',1,0)
o_flag = v_flag
0_count = v_count

filter t/r:
condition: o_flag=1 AND o_filter=1 AND 0_count!=2

draw informatica architecture 8.6 ?

3874

---

Performance tuning in UNIX for informatica mappings?

2570

---

What are mapplets?

1277

---

Explain why we use partitioning the session in informatica?

1097

---

What is aggregate cache in aggregator transformation?

1148

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2362

---

what is the -ve test case in your project.

2409

---

Why update strategy and union transformations are active? Explain with examples.

1243

---

Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1907

---

Which transformation is needed while using the Cobol sources as source definitions?

1177

---

What is the scenario which compels informatica server to reject files?

1073

---

How are indexes created after completing the load process?

1650

---

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201

---

Why is sorter an active transformation?

1131

---

What is the fact table?

1074

---