Answer Posted / radhakrishnansk

Considering the source as flat file.
src-->Src qual ---> sorted transfomation -->trgt
|
|---> trgt
In sorted transformation, we can choose distict in
properties. So the duplicate is avoided.

correct me if I am wrong

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?

1471

---

How to do the error handling of if ur source is flatfiles?

1515

---

What is the difference between writing a joiner query in ANSI style and THETA style?

1925

---

What is joiner change?

687

---

Enlist few areas or real-time situations where informatica is required.

597

---

---

Define update strategy?

641

---

Can u generate reports in Informatica?

661

---

Parameter and variable differences

1624

---

What is an aggregator transformation?

617

---

what are 3 tech challenges/ common issues you face?

1893

---

How can we use mapping variables in informatica? Where do we use them?

622

---

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?

1055

---

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

5843

---

expain about the tune parameters?

1890

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

636

---