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

i have two sources two flatfiles same structure
one flatfile contain 100 million recs
another flatfile contain 10 million recs
i have to connect single target(performance oriented answer)
what are the steps we have to do this scenario

Question Posted / srikanth

Answer Posted / 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.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1055

What is joiner change?

684

Explain the shared cache and re-cache?

613

What is union transformation in informatica?

701

What are batches?

623




How to load the name of the current processing flat file along with the data into the target using informatica mapping?

702

What is the use of code page?

610

Whats the difference between informatica powercenter server, repositoryserver and repository?

679

Explain pushdown optimization $pushdownconfig parameter - informatica

703

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

1746

What does command task mean?

614

Which is the t/r that builts only single cache memory?

714

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

606

Write the different tools in the workflow manager?

576

How to extract the informatica rejected data?

757