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
tell me the rules and responsblites in our project(my project is development)
Explain in detail about scd type 1 through mapping.
What is the function of look up transformation?
What is an Integration service in Informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
How you know when to use a static cache and dynamic cache in lookup transformation?
How many number of sessions can one group in batches?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
What is olap (on-line analytical processing?
can anyone explain me about retail domain project in informatica?
What is Index Caches size?
What are mapplets? How is it different from a Reusable Transformation?
Enlist the advantages of informatica.
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.