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?

  • Interview Candidate
  • 17
  • 15136

Showing Answers 1 - 17 of 17 Answers

Srinivas

  • Aug 14th, 2006
 

Declere Target table twice in the mapping and move the output to both the target tables.

shanthi

  • Aug 21st, 2006
 

Don't choose the select distinct option and run the session again.u will find duplicate rows in u r target.

shivaleela

  • Aug 31st, 2006
 

Thanks  srinivas n shanthi  for ur answer.

 But my querie is different means suppose if u hv 10 records in source thn i want same 10 records should b loaded twice such that I should get all records twice means 20 records n only in single target table .

  Was this answer useful?  Yes

Sriharsa Misra

  • Sep 1st, 2006
 

use this syntex

insert into table1 select * from table1

(table1 is the name of the table)

  Was this answer useful?  Yes

Parimala

  • Sep 5th, 2006
 

If the record is entered in the table, and always the records have to be duplicated, then its better to have a trigger which fires for every insert on the table.

  Was this answer useful?  Yes

varun

  • Sep 29th, 2006
 

It can be done by using two field name with diff name,and connecting two the same

  Was this answer useful?  Yes

rammohan

  • Jan 11th, 2007
 

If you ran session twise we can get the same record tiwse in a table.without selecting the trucate Option in session level.

tomtwj

  • Mar 15th, 2007
 

1.How to enter same record twice in target table? give me syntax.
Another way:  Router Transf can be used and use the same conditions for both groups which lets all rows pass through.  Then insert the same target table.

shanthi1

  • Mar 18th, 2007
 

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

  Was this answer useful?  Yes

shanthi1

  • Mar 18th, 2007
 

How to get particular record from the table in informatica?


using a where clause


and to get the records starting with A..write an SQL query in Source Qualifier transformation as..

SELECT * FROM TABLENAME WHERE ENAME LIKE 'A%';

  Was this answer useful?  Yes

senthilkar

  • Dec 17th, 2007
 

3.How to create primary key only on odd numbers?
use Mod function in the aggregator to find odd and even numbers... then filter the records with odd no and use sequence generator


4. How to get the records starting with particular letter like A in informatica?
Use substr(A%) in aggregator trans

Anshul

  • Jul 20th, 2011
 

This would add duplicates for all the rows including those that already existed in the table.

  Was this answer useful?  Yes

Shaik

  • Jul 27th, 2011
 

In mapping drag source 2 times and make sure that source and target doesn't have any key constraints.
Then add UNION TRF and link both sources to union and link output ports from union to target.

u ill get multiple records.

  Was this answer useful?  Yes

Ranga rao

  • Aug 4th, 2011
 

Use union Transformation

  Was this answer useful?  Yes

alekhya

  • Aug 7th, 2011
 

Create two target instance tables

  Was this answer useful?  Yes

priyank_divya

  • Jun 11th, 2012
 

Hi Shiva,

You can use Normalizer t/f to achieve the desired output. There is an "Occur" option in Normalizer in which you can mention the no of times you want to load the same source data into target.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions