Answer Posted / tanay

You can use Head and Tail commands in UNIX to achieve the
same. Please correct me if i am wrong.

What is the procedure for creating independent data marts from informatica 7.1?

1000

---

r u done any partitions in ur project?

1751

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1730

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1072

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1023

---

What do you understand by SOA of Informatica?

925

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

9972

---

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1715

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1195

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2076

---

What do you mean incremental aggregation?

1010

---

How we can create indexes after completing the loan process?

1142

---

whats the logic to load the lower level of granularity of data to fact table.

2206

---

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.

2140

---

What is the reusable transformation?

1006

---