can a port in expression transf be given the name DISTINCT
Answer Posted / my
Yes, it can be used. Port name is just a name and
informatica do not validate the port name as long as it is
unique among all the ports in one particular expression.
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
Explain what are the different types of transformation available in informatica.
What are junk dimensions?
What are the main issues while working with flat files as source and as targets ?
What is a joiner transformation and why it is an active one?
Define Pmrep command?
What is meant by lookup transformation? Explain the types of lookup transformation?
What is expression transformation?
How to use procedural logic inside infromatica?
How will the document be delivered to me?
What is Index Caches size?
What is a snowflake schema?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How can you validate all mappings in the repository simultaneously?
What is a predefined event?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?