1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

if soource is having 10 records how will u insert 20
records to target

Question Posted / sunil.knl

Answers were Sorted based on User's Feedback



if soource is having 10 records how will u insert 20 records to target..

Answer / sreekanth

select * from table_name
union all
select * from table_name;

Is This Answer Correct ?    13 Yes 0 No

if soource is having 10 records how will u insert 20 records to target..

Answer / james

Take two target instances in the mappings
This will load 20 records in the target

Is This Answer Correct ?    2 Yes 0 No

if soource is having 10 records how will u insert 20 records to target..

Answer / priyank

Take 2 instances of source and join them unsin UNION
transformation(provided the target structure is same as the
source structure).

SQ1 --> UNION --> EXP --> Target
SQ2

Is This Answer Correct ?    2 Yes 0 No

if soource is having 10 records how will u insert 20 records to target..

Answer / prabu

hi sanjay,
me too think the same way to thought.. are u sure this is
the right way to do.

Is This Answer Correct ?    1 Yes 1 No

if soource is having 10 records how will u insert 20 records to target..

Answer / saravana

we can user Normalizer transformation, to convert a row into double row and then load it into target

Is This Answer Correct ?    0 Yes 0 No

if soource is having 10 records how will u insert 20 records to target..

Answer / sanjay

keep the "Truncate Target Table Option" uncheck in the
session and run the workflow two times..
You can get the 20 records..

Is This Answer Correct ?    4 Yes 7 No

Post New Answer

More Informatica Interview Questions

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

What do think which one is the better joiner or look up?

0 Answers  

What is the meaning of decode in informatica?

0 Answers  

Different types of Power center errors?

1 Answers   Cinterco, IBM,

What is rank transformation?

0 Answers  




What is Factless fact table ???

12 Answers   Satyam, Tech Mahindra,

what is incremental data aggregation?

3 Answers   IBM,

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

If a session fails after loading of 10,000 records in to the target.How can you load the records from 10001?

5 Answers   TCS,

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?

0 Answers  

my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,

For more Informatica Interview Questions Click Here
Categories