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
can we override a native sql query within informatica? Where do we do it? How do we do it?
How can we create index after completion of load process?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What is fact table? Explain the different kinds of facts.
In which transformation you cannot drag ports into it?
How can we delete duplicate rows from flat files?
What are the new features of Power Center 5.0?
Can we create two repositories on same database instance in oracle?
What is Data Caches size?
Which is the t/r that builts only single cache memory?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What the difference is between a database, a data warehouse and a data mart?
What does refresh system mean, and what are its distinctive choice?
Can we create a node as a gateway node and the same node can be assigned to a grid?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com