what is the process we used in joiner transformation,there
is no matching column in sources?
Answer Posted / emmanuel
Create a dummy port in both the sq transforamtion and join
based on the dummy values
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
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?
Is there any way to read the ms excel datas directly into informatica?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is informatica worklet?
what is SDLC way of code development?
Explain the pipeline partition with real time example?
How can we use mapping variables in informatica?
What is domain in terms of informatica?
What are some examples of informatica etl programs?
what is song in infrmatica...?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
What is olap (on-line analytical processing?
What is union transformation?
Mention few advantages of router transformation over filter transformation.