if soource is having 10 records how will u insert 20
records to target
Answer Posted / priyank
Take 2 instances of source and join them unsin UNION
transformation(provided the target structure is same as the
source structure).
SQ1 --> UNION --> EXP --> Target
SQ2
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is informatica powercenter repository?
What are the designer tools for creating transformations?
How to delete duplicate row using informatica?
wf dont have integration severances how you can run?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
Please let me know how to make Data masking in informatica..
Explain load alternative records / rows into multiple targets - informatica
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?
In informatica workflow manager, how many repositories can be created?
What is a repository manager?
r u done any partitions in ur project?
What is complex mapping?
what is SDLC way of code development?
What are the main features of Oracle 8i with context to datawarehouse?
What are the components of the workflow manager?