Srinivas
Answered On : Aug 14th, 2006
Declere Target table twice in the mapping and move the output to both the target tables.
1 User has rated as useful.
Login to rate this answer.
shanthi
Answered On : Aug 21st, 2006
Don't choose the select distinct option and run the session again.u will find duplicate rows in u r target.
1 User has rated as useful.
Login to rate this answer.
shivaleela
Answered On : 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 .
Login to rate this answer.
Sriharsa Misra
Answered On : Sep 1st, 2006
use this syntex
insert into table1 select * from table1
(table1 is the name of the table)
Login to rate this answer.
Parimala
Answered On : 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.
Login to rate this answer.
varun
Answered On : Sep 29th, 2006
It can be done by using two field name with diff name,and connecting two the same
Login to rate this answer.
rammohan
Answered On : 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.
1 User has rated as useful.
Login to rate this answer.
1.How to enter same record twice in target table? give me syntax.
Anotherway: Router Transf can be used and use the same conditions for both groupswhich lets all rows pass through. Then insert the same target table.
1 User has rated as useful.
Login to rate this answer.
insert into table1 select * from table1 ........this may not be useful if the table has contraints on it
Login to rate this answer.
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%';
Login to rate this answer.
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
1 User has rated as useful.
Login to rate this answer.
Anshul
Answered On : Jul 20th, 2011
This would add duplicates for all the rows including those that already existed in the table.
Login to rate this answer.
Shaik
Answered On : 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.
Login to rate this answer.
Ranga rao
Answered On : Aug 4th, 2011
Use union Transformation
Login to rate this answer.
alekhya
Answered On : Aug 7th, 2011
Create two target instance tables
Login to rate this answer.
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.
Login to rate this answer.
by using BELOW SCENARIO we can do it the flow is like this
SRC-->SQ-->EXP-->T1
T2
Login to rate this answer.
