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.

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?

1925

---

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.

2152

---

What are connected or unconnected transformations?

1056

---

how we can load rejected record's at run time?(not through bad files)

2324

---

Explian the Process of deployment groups in informatica

1001

---

How we can use union transformation?

1001

---

Enlist the advantages of informatica.

1014

---

What is the use of source qualifier?

1081

---

What is informatica powercenter repository?

1147

---

What is the difference between informatics 7x and 8x and what is latest version?

1038

---

Explain scd type 3 through mapping.

926

---

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

1097

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1454

---

What are junk dimensions?

1032

---

Design time, run time. If you don't create parameter what will happen

1802

---