how to return multiple columes through through un-connect
lookup?
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 |
What is a sequence generator transformation?
Which version configuration tool used in ur project?
Why sorter is an active transformation?
What is CHECK-IN CHECK-OUT. Please explane me?
Describe expression transformation?
What is domain in terms of informatica?
What is the command used to run a batch?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?
Why you use repository connectivity?
what is threshold error in informatica?
if soource is having 10 records how will u insert 20 records to target