Answer Posted / amedela chandra sekhar

If two flat files are having same structure then we can join
by using Union transformation.








Chandu

What is substr in informatica?

675

---

explan ur project architecture?

1608

---

Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7778

---

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?

1477

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

1647

---

---

How to partition the Session?

654

---

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1522

---

What is decode in static cache?

600

---

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?

1063

---

What are the features of complex mapping?

656

---

Difference between Target-based loading and constraint-based loading?

564

---

Describe data concatenation?

589

---

Explain how to import oracle sequence into informatica?

598

---

How to call shell scripts from informatica?

586

---

Why filter transformation is an active one?

577

---