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

What is lookup transformation?

807

---

What does cheating measurement mean?

789

---

Does an informatica transformation support only aggregate expressions?

796

---

can you please explain me pre session and post session options?

6885

---

To import the flat file definition into the designer where should the flat file be placed?

833

---

What are mapplets?

1000

---

Which files are created during the session rums by informatics server?

907

---

Briefly define a session task?

790

---

Briefly define reusable transformation?

836

---

What does update strategy mean, and what are the different option of it?

826

---

hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9433

---

What is an Integration service in Informatica?

893

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2015

---

What are some examples of informatica etl programs?

726

---

Define the various join types of joiner transformation?

760

---