Answer Posted / srinu

The main Data sorces for Informatica,,,

1)Relational Databases,,like(oracle,Teradata,Sql server,,,)

2)Flat File (data in a Notepad(Text format)) in a
Perticular path.



srinu,,,,,

Informatica settings are available in which file?

603

---

What is the sequence generator transformation in informatica?

625

---

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

615

---

How does the aggregator transformation handle null values?

714

---

What is the function of aggregator transformation?

589

---

---

Explain the etl program with few examples.

560

---

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

1933

---

Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

744

---

What does command task mean?

622

---

What is a filter transformation?

579

---

What is the status code in stored procedure transformation?

695

---

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4325

---

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?

1065

---

Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?

1635

---

Write the prerequisite tasks to achieve the session partition?

658

---