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 polling?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is a configuration management?
What is a sequence generator transformation?
Diff b/w ShortCut and reusabel Object ?
Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks
how much memory (size) occupied by a session at runtime
In development project what is the process to follow for an etl developer from day1
What are pre and post-session shell commands?
What is staging area?
What is Cognos script editor?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?