Answer Posted / sarthak

With the help of command task...

cd dir_path
cat 1st_filename 2nd_filename >> 3rd_filename

Then,

create 1 flatfile and connect it to target.

In session property,
give the filename: 3rd_filename and its path

What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?

1075

---

what is degenerated dimension?

3983

---

In which transformation you cannot drag ports into it?

1311

---

Describe data concatenation?

1072

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1575

---

What is complex mapping?

1113

---

Can we override a native sql query within informatica?

1032

---

What do you mean incremental aggregation?

1072

---

Clarify the utilization of aggregator cache record?

988

---

What are the guidelines to be followed while using union transformation?

1134

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1967

---

Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?

2173

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1039

---

How are the sources and targets definitions imported in informatica designer?

1097

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2716

---