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

Categories >> Software >> Data Warehouse >> Informatica
Suggest New Category

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

Question Posted / sunil.knl

6 Answers
12536 Views
HCL, I also Faced
E-Mail Answers

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

explan ur project architecture?

0 Answers TCS,

What are the diffrences between joiner transformation and source qualifier transformation?

2 Answers

There are 2 files, Master and User. We need to compare 2 files and prepare a output log file which lists out missing Rolename for each UserName between Master and User file. Please find the sample data- MASTER.csv ---------- Org|Tmp_UsrID|ShortMark|Rolename ---|---------|----------|------------ AUS|0_ABC_PW |ABC PW |ABC Admin PW AUS|0_ABC_PW |ABC PW |MT Deny all GBR|0_EDT_SEC|CR Edit |Editor GBR|0_EDT_SEC|CR Edit |SEC MT103 GBR|0_EDT_SEC|CR Edit |AB User USER.csv -------- Org|UserName|ShortMark|Rolename ---|--------|---------|------------ AUS|charls |ABC PW |ABC Admin PW AUS|amudha |ABC PW |MT Deny all GBR|sandya |CR Edit |Editor GBR|sandya |CR Edit |SEC MT103 GBR|sandya |CR Edit |AB User GBR|sarkar |CR Edit |Editor GBR|sarkar |CR Edit |SEC MT103 Required Output file: --------------------- Org|Tmp_UsrID|UserName|Rolename |Code ---|---------|--------|------------|-------- AUS|0_ABC_PW |charls |ABC Admin PW|MATCH AUS|0_ABC_PW |charls |MT Deny all |MISSING AUS|0_ABC_PW |amudha |ABC Admin PW|MISSING AUS|0_ABC_PW |amudha |MT Deny all |MATCH GBR|0_EDT_SEC|sandya |Editor |MATCH GBR|0_EDT_SEC|sandya |SEC MT103 |MATCH GBR|0_EDT_SEC|sandya |AB User |MATCH GBR|0_EDT_SEC|sarkar |Editor |MATCH GBR|0_EDT_SEC|sarkar |SEC MT103 |MATCH GBR|0_EDT_SEC|sarkar |AB User |MISSING Both the files are mapped through Organization, Shor_mark. So, based on each Organization, Short_Mark, for each UserName from User.csv, we need to find the Matching and Missing Rolename. I am able to bring Matching records in the output. But really I don't find any concept or logic to achieve "MISSING" records which are present in Master and not in User.csv for each UserName. Please help out guys. Let me know if you need any more information. Note:- In User.csv file, there are n number of Organization, under which n number Shortmark comes which has n number of UserName.

0 Answers

2 Answers Sapient,

Hi I have a source (flat file) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd "[19012005124259]_Anfrage-Vendors.doc [19012005124336]_Anfrage.xls" 103 def "[19012006092602]_IMG_0310.JPG 19012006092631]_IMG_0311.JPG [19012006092702]_IMG_0312.JPG [19012006092727]_IMG_0313.JPG" But I need to generate duplicate records based on attachments column. Target (Table) like ID Name Attachments 101 abc [07012005072902]_CMM27-11-01 Page106 (2).pdf 102 bcd 19012005124259]_Anfrage-Vendors.doc 102 bcd [19012005124336]_Anfrage.xls 103 def [19012006092602]_IMG_0310.JPG 103 def [19012006092631]_IMG_0311.JPG 103 def [19012006092702]_IMG_0312.JPG 103 def [19012006092727]_IMG_0313.JPG 103 def [19012006092750]_IMG_0314.JPG 103 def [19012006092814]_IMG_0315.JPG Here no. of Attachments we can't decide because it is dynamic. It will be great if somebody help me on this. Thanks in Advance. ganga

2 Answers

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers TCS,

what type of problem you faced insales project or insurance project

1 Answers Sony,

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers Cap Gemini,

What is a design?

1 Answers

Two Default User groups created in the repository are ____ and ______

2 Answers

how can u avoid duplicate rows in flat file?

4 Answers CTS, Wipro,

How many repositories can we create in Informatica??

9 Answers IBM, Patni,

For more Informatica Interview Questions Click Here