How can we get two output ports in un-connect transformation?
Answer Posted / prabhu
You can use lookup override to concat two columns from tble
and return as single column(eg COL1||','||col2 as
COLUMN).You can pass this to expression transformation and
parse it to split it again
Prabhu
www.iskilltech.com
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What are batches?
Write the unconnected lookup syntax?
Enlist the various types of transformations.
What are the features of complex mapping?
What are different types of transformations available in informatica?
How many numbers of sessions can one group in batches?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What is an unconnected transformation?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
Difference between Data and Index Caches?
What is Cognos script editor?
What is a mapplet/worklet in informatica?
What is joiner transformation in informatica?
Where do we use mapping variables in informatica?