Answer Posted / rajesh
yes we can ,by creating dummy ports in expression transmission like forjoin and tojoin ,in joiner transformation condition is forjoin=tojoin and output is m*n format
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is data movement mode in Informatica and difference between them?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is session task and command task?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
How to do unit testing in informatica?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What are the types of presistent cache in look up tr.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What are connected or unconnected transformations?
What are the modules in Power Center
What is meant by a domain?
When do you use sql override in a lookup transformation?
In which transformation you cannot drag ports into it?
Differentiate between a repository server and a powerhouse?
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?