how to return multiple columes through through un-connect
lookup?
Answer Posted / 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.
Is This Answer Correct ? | 15 Yes | 0 No |
Post New Answer View All Answers
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Explain constraint based loading in informatica
Explain in detail about scd type 1 through mapping.
What is powercenter on grid?
What is depict expression change?
Where do we use mapping variables in informatica?
Explain load alternative records / rows into multiple targets - informatica
What is meant by query override?
What are the different versions of informatica?
What are the new features of informatica 9.x developer?
How identifying bottlenecks in various components of informatica and resolving them?
What is a joiner transformation and why it is an active one?
What is the function of look up transformation?
What is the cumulative sum and moving sum?
Reusable transformation and shortcut differences