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 |
SOURCE 1 a 1 b 1 c 2 a 2 b 2 c TARGET 1 A B C 2 A B C In oracle & informatica level how to achieve
How can i send first half of the records to one target and Remaining to other target?
What is a repository? And how to add it in an informatica client?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Parameter and variable differences
i have different sources in different databases ,that sources may be 100 tables i want to load these tables in to single target how to pearform the task
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
My source is flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100
Difference between Target-based loading and constraint-based loading?
Which is the best place to learn Informatica Powercenter Online Training?