Answer / swetha

If you parttion a session with a relational target
informatica server creates multiple connections o the
target database to write target data concurently.If you
partition a session with a file target the informatica
server creates one target file for each partition. yoU can
configure session properties to merge these target files.

Answer / isha_gtb

How to Partition Flat files?

Sessions can run on single or multiple nodes (in a grid). Row distribution depends on two factors –

Number of Threads
Number of Partitions
A. Flatfile Sources

Partitioning allowed for both Direct and Indirect type Flat file sources
Some Source Qualifier transformation with subsequent transformations like Joiner transformation (configured with sorted input) require sorted row order.
It is important to preserve the row order while distributing rows between partitions. This is to be achieved by setting an appropriate value for “Concurrent Read Partitioning” in Session properties.
B. Flatfile Targets

While writing a target, you can configure Informatica to write to different files one for each partition or you can configure to write data concurrently.
All these files can be merged to one file when the process completes as indicated in the merge type
To merge the files, you can either set below properties / write a post session command – Merge Type, Merge File Directory, Merge File Name
Informatica allow you to merge the target files in three different ways –
Sequential Merge – Informatica creates one output file for each partition and sequentially merge them to a single file when the session completes
Concurrent Merge – Informatica writes the output data for all partitions concurrently on to one merge file. Sorting order will not be preserved in this type of merge
File List – Informatica creates and write one output file for each partition and write the file directory and file name to a separate list file.





Ref :

http://etllabs.com/informatica/informatica-partitions/4810/

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  

---

Implementation methodology

0 Answers  

---

Is there any target staging area in informatica not staging area

0 Answers   Syntel,

---

how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

What is an active transformation?

0 Answers   Informatica,

---

What is the sequence generator transformation in informatica?

0 Answers  

---

what is the purpose of surrogate key and diff between primary key&surrogate key

1 Answers   Cap Gemini,

---

How do you change parameter when you move it from development to production.

1 Answers  

---

how to create user defined function (udf) in informatica

0 Answers   Informatica,

---

what is tha tracesing level? and difference betweentrace in normal and verbose and nonverbose?

2 Answers  

---