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.

I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  

---

we have three columns and two rows. col1 col2 col3 a b c want to change into 2 columns and 3 rows ,how? col1 a col2 b col3 c which transformation u'll use and how?

3 Answers   Cognizant,

---

What are the reusable transforamtions?

1 Answers  

---

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

---

PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U

2 Answers  

---

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

Do you find any difficulty while working with flat files as source and target?

0 Answers  

---

What are the parts of Informatica Server?

1 Answers   Cognizant,

---

What is the approximate size of data warehouse?

6 Answers   Accenture, i3 Solutions,

---

What is Performance tuning in Informatica?

1 Answers   CTS, GE, TCS,

---

How to generate sequence numbers?

0 Answers  

---

what is degenerated dimension table with scenario

2 Answers   HCL,

---