Answer Detail: RE: 1.how to enter same record twice in target table? ...

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Print |

Question: 1.how to enter same record twice in target table? give me syntax.

2. how to get particular record from the table in informatica?

3.how to create primary key only on odd numbers?

4. how to get the records starting with particular letter like A in informatica?

September 09, 2006 08:59:24	#4
Sriharsa Misra	Member Since: Visitor Total Comments: N/A
RE: 1.how to enter same record twice in target table? ...
use this syntex insert into table1 select * from table1 (table1 is the name of the table)

Back To Question