Interested to Buy Any Domain ? << Click Here >> for more details...
how to return multiple columes through through un-connect
lookup?
- 1 Answers
- 6890 Views
- DELL, I also Faced
- E-Mail Answers
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
what are factless facts? And in which scenario will you use such kinds of fact tables.
How to configure mapping in informatica?
What is a shortcut and copy in Informatica and how two are different with each other?
what is informatica metadata?
What are the mapping parameters and mapping variables?
How to join three sources using joiner?
Target increases every day even though no new record was inserted
Explain the shared cache and re-cache?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are junk dimensions?
What is the Rank index port in Rank transformation?
how to load dimension table and fact table. plz tell me the steps.
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Why do you use Mapping Parameter and mapping variable?
What is union transformation in informatica?
