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/

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2197

---

Describe data concatenation?

1081

---

What is pmcmd command?

1108

---

without table how to come first record only in oracle?

2250

---

Explain what are the different versions of informatica?

1097

---

What does refresh system mean, and what are its distinctive choice?

1171

---

What is rank index in rank transformation?

1078

---

Explain the etl program with few examples.

1048

---

In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.

2062

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4160

---

Describe the impact of several join conditions and join order in a joiner transformation?

1059

---

What does cheating measurement mean?

1051

---

What is the difference between a connected look up and unconnected lookup?

965

---

Explain sessions?

1053

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1246

---