how to return multiple columes through through un-connect
lookup?
- 1 Answers
- 5952 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 |
expain about the tune parameters?
i have an aggregater in my mapping and no group by port on any column and i ampassing 100 rows through aggregater,so how many rows i will get as out put from aggregater
What is a snowflake schema?
What is tracing level and what are the types of tracing level?
What are the settings that you use to configure the joiner transformation?
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Could you explain what is enterprise data warehouse?
What is meant by LDAP users?
How to update a particular record in target with out running whole workflow?
Why use the lookup transformation ?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
Teradata 
