Answer / prabhu

You can use lookup override to concat two columns from tble
and return as single column(eg COL1||','||col2 as
COLUMN).You can pass this to expression transformation and
parse it to split it again

Prabhu
www.iskilltech.com

Answer / ayodya

Using the Concat function can return Output

How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,

---

What are connected or unconnected transformations?

0 Answers   Informatica,

---

What is synonym?

2 Answers   Patni,

---

if the session continuous run what can we do. means shall we stop the session or abort session. what is the correct reasion. why this situation occurs

1 Answers  

---

For stage table data processing, suppose in first run we processed 8 records out of 10 records then in 2nd run we should consider only not processed records (here total no of records =2) along with new records which got loaded in stage table thru real time mapping. Note : In this example, 8 records are those records for which we got transaction number after lookup on trn_no_cod table and 2 records for which lookup returns trn_no as NULL

1 Answers  

---

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

---

Explian the connected and unconnected lookup transformation

1 Answers   Informatica,

---

How big was your fact table

0 Answers  

---

Does Facttable Normalized or Denormalized?

2 Answers   IBM,

---

How to merge First Name & Last Name?

8 Answers  

---

what r the values tht r passed between informatics server and stored procedure?

1 Answers  

---

In a mapping i have three dimensions. If i want to pass a same surrogate key value to all the three dimensions by using one sequence generator is possible?If the mapping is containing single flow? And in the same case if the mapping is contaning 3 flows for the three dimensions then by using one sequence generator can we populate surrogate key (same value) to all the three dimensions?

6 Answers   IBM,

---