Interested to Buy Any Domain ? << Click Here >> for more details...
how to return multiple columes through through un-connect
lookup?
- 1 Answers
- 6979 Views
- DELL, I also Faced
- E-Mail Answers
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 the main advantage of unconnected lookup
How to retrieve last two days updated records?
write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15
Which version configuration tool used in ur project?
What are the different components of powercenter?
Where can we find the throughput option in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What happens when a session fails and you click on recover?
What is union transformation in informatica?
How IN function works in informatica? Is it similar that of oracle IN function or different? Explain
What is batch and describe about types of batches?
In dimension and fact table? which one holds big data?
Teradata 
