Answer / babu

Hi Teja,
The two sources are haveing same structure,so beter to
use list file,to load the data into single TARGET.

Procedure:
----------
1.Place the two source paths in a note pad and
save as it '.list' format.
2.create a maping as per your requirement in
that mapping you have to take only one source no need to
take two sources.
3. Create a session and workflow.
4.In session give a SOURCE FILE PATH
is '.list' file and SOURCE FILE TYPEA as INDIRECT.

Let me know if any thing wrong.

Thanks,
dwarak.vbr@gmail.com

Answer / srikanth

Hi,

Both teja and Babu Answers are correct..

But here we need to consider Performance wise which one is
better.

here we have only two flat files one is having 100 million
records and second one having 10 million records.

union transformation can supports for flat files also and it
is acting as union all(don't worry about this).

first drag the 100 million records source and then drag the
10 million records source on mapping designer.
connect these two sources to union transformation.
union transformation can merge the Data By COLUMN by COLUMN.
so it is trying to merge only 10 million records with
existing 100 million records

Then we can tune the performance here.

if we have lot of flat files(same structure) then we have to
go for file indirect.

Answer / sudheer

As u r using source as flat file so u can go for partitioning preferably Single-Thread or Multi-Thread partitioning.

Answer / tejaetl

i answered this question both the flatfiles connet to union

connect to single target

If the values in a row are 1,2,3,3,4,,4,5 then how a rank transformation can rank these values

6 Answers   TCS,

---

Kimball and Inmon methodologies?

2 Answers  

---

What are the joiner caches?

3 Answers   Informatica,

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

What's the layout of parameter file (what does a parameter file contain?)?

0 Answers   Cognizant,

---

Why is sorter an active transformation?

0 Answers  

---

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

---

What are the different transaction levels available in transaction control transformation?

0 Answers   Informatica,

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

Which are the different editions of informatica powercenter that are available?

0 Answers  

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

---