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 can you define user defied event?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How many transformations can be used in mapplets.
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Differentiate between a repository server and a powerhouse?
Which files are created during the session rums by informatics server?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
In warehouses how many schemas are there?
What is lookup transformation?
On which transformations you created partitions in your project?
What is the scenario which compels informatica server to reject files?
Explain incremental aggregation in informatica
Under which circumstances, informatica server creates reject files?
define galaxy repository in informatica
How do you load only null records into target? Explain through mapping flow.