Answer Posted / reni

Create one dummy record for each table:
from 2 source qualifiers connect a expression
transformation to create a output port as "Dummy" & assign
the value "1" to that port.
Then in joiner join based on this dummy port of two
different source.

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

2051

---

can anyone explain me about retail domain project in informatica?

7996

---

what are the Methods For Creating Reusable Transformations?

1249

---

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?

1304

---

What is the use of an aggregator cache file?

1245

---

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

1313

---

What is sq transformation?

1226

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2289

---

What is the use of source qualifier?

1182

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1729

---

Performance tuning in UNIX for informatica mappings?

2620

---

What is a standalone command task?

1247

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1202

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1184

---

What are the different lookup cache(s)?

1163

---