GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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?





March 03, 2007 10:43:01 #9
 shanthi1   Member Since: March 2007    Total Comments: 6 

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

insert into table1 select * from table1  ........this may  not be useful if the table has contraints on it

     

 

Back To Question