Answer Posted / sanjay

While loading the flat file target integration service do not have to prepare insert/update/delete sql statements, also there should not be any database overhead like unique index validation or constraints checking for the target data and no auto data type conversion takes place while writing to flat file target.

What is the fact table?

993

---

what is the size of u r source(like file or table)?

2199

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2508

---

can any one give some examples for pre sql and post sql(Except dropping and creating index).

4035

---

How many ways are there to do 'remove duplicate records in informatica'?

954

---

SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2057

---

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?

1913

---

How you can differentiate between connected lookup and unconnected lookup?

1006

---

What is a difference between complete, stop and abort?

1032

---

Explain lookup transformation is active in informatica

1034

---

What is a repository? And how to add it in an informatica client?

1082

---

Is it possible to create multiple domains on a single Informatica server?

1180

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

950

---

What will be the approach?

929

---

Why update strategy and union transformations are active?

989

---