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
Explain the difference between mapping parameter and mapping variable?
How to create or import flat file definition in to the warehouse designer?
What does reusable transformation mean?
What is informatica? Why do we need it?
Explain scd type 3 through mapping.
What are the differences between joiner transformation and source qualifier transformation?
What are the tasks that source qualifier perform?
What is rank index in rank transformation?
How union transformation is used?
Is stop and abort are same in informatica?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to use procedural logic inside infromatica?
What is main use of mapplet?
whats the logic to load the lower level of granularity of data to fact table.
4 yrs etl devloper roles and responsibilities?any body give solutions