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

Answer Posted / sudheer

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

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways a relational source definition can be updated and what are they?

585


How to extract the informatica rejected data?

757


What could be the possible resons of locks by user?

665


Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

1854


Write the program through which the records can be updated?

520






How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

629


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4988


What is a repository? And how to add it in an informatica client?

664


What are batches?

623


 Informatica Checkpoints

2858


Briefly explain the aggregator transformation?

604


What is the scenario which compels informatica server to reject files?

608


HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1482


Different qualification between a related rotate toward the sky and isolates look upward?

556


How to Create a folder using pmrep command?

626