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 blocking transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Where do we use mapping variables in informatica?
in reporting we add some new objects,how we get the count of the newly added objects to the report
How many ways a relational source definition can be updated and what are they?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is olap (on-line analytical processing?
How to convert multiple rows to single row (multiple columns) in informatica
What is a sorter transformation?
What is a router transformation?
Global and Local shortcuts. Advantages.
What are the advantages of using informatica as an etl tool over teradata?
Enlist few areas or real-time situations where informatica is required.