Answer Posted / anoymous

This can be done by File list or File repository. Create
rep.txt file list in that write all the paths of the i lac
flat files.
in session level set the following attributes
source file name indirect
source file directory filelist path address
source file name rep.txt

Where is metadata stored?

1118

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1033

---

In how many ways we can create ports?

1124

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1114

---

How do you load unique records into one target table and duplicate records into a different target table?

1263

---

What is union transformation in informatica?

1147

---

is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?

1206

---

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

1130

---

What is Session and Batches?

1109

---

Please let me know how to make Data masking in informatica..

1729

---

Describe the impact of several join conditions and join order in a joiner transformation?

1063

---

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

1086

---

can you please explain me pre session and post session options?

7575

---

How can we use batches?

1026

---

What is fact table? Explain the different kinds of facts.

1079

---