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

r u done any partitions in ur project?

Question Posted / chandumba2005


r u done any partitions in ur project?..

Answer / Sachin

Yes, I have worked on data partitioning projects where data is divided into smaller, manageable pieces based on certain criteria such as date range, geography, or sales volume. Partitioning can improve the performance of queries by reducing the amount of data that needs to be scanned and improving data load times. Informatica PowerCenter provides various options for data partitioning like Range-based, Hash-based, and List-based partitions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

In which transformation you cannot drag ports into it?

1 Answers   Informatica,

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

explan ur project architecture?

1 Answers   TCS,

What are the joiner caches?

3 Answers   Informatica,

Difference Between ETL & ELT?

1 Answers   TCS,

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1 Answers  

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,

Tell me about Propagate functions in informatica

1 Answers  

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers  

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

What is Collect performance data in informatica and what is the use of it.

1 Answers   Informatica,

to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories