if soource is having 10 records how will u insert 20
records to target
Answer Posted / sreekanth
select * from table_name
union all
select * from table_name;
Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
How might you approve all mappings in the archive all the while?
Parameter and variable differences
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 event and what are the tasks related to it?
What is the scenario which compels informatica server to reject files?
How can you validate all mappings in the repository simultaneously?
If informatica has its scheduler why using third party scheduler?
Why do we need informatica?
Define mapping and session?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
difference between repository database and repository service?
How to load data in informatica ?
In informatics server which files are created during the session rums?
In development project what is the process to follow for an etl developer from day1
What are the differences between oltp and olap?