Answer / dharmendra singh

Suppose your look table has f_name,m_name,l_name and you
are using unconnected lookup.In override SQL of lookup use
f_name||~||m_name||~||l_name you cna easily get this value
using unconnected lookup in expression.use substring
function in expression transformation to separate these
three columns and make then individual port for downstream
transformation /Target.

Kimball and Inmon methodologies?

2 Answers  

---

what is lookupoverriding?

1 Answers  

---

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

---

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers   Patni,

---

How to delete duplicate record in Informatica?

7 Answers  

---

What are the basic needs to join two sources in a source qualifier?

4 Answers  

---

can we use lookup t/r in flat files?what are the t/r's can be used in flat files when compared to relational DB?

2 Answers   IBM,

---

Explain lookup transformation is active in informatica

0 Answers   Informatica,

---

In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,

---

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,

---

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers  

---

how many types of dimensions are available in informatica?

0 Answers  

---