Answer Posted / pushparao

if there is no matching column two flat files, that means
two tables are different,no need to join the source
definitions in the designer.
there is possibility to join them.
create common columns in both expression transformations.
seqgen
|
sd-->sq-->expr
Joiner-->td
sd-->sq-->expr
|
seqgen

What the difference is between a database, a data warehouse and a data mart?

588

---

Mention a few design and development best practices for informatica?

555

---

explain one complex mapping with logic? sales project?

6136

---

What is native users?

715

---

Target increases every day even though no new record was inserted

1103

---

---

What is domain and gateway node?

688

---

Can we override a native sql query within informatica?

624

---

What is joiner transformation in informatica?

623

---

What are the types of data warehouses?

936

---

What is rank transformation?

570

---

What is an aggregator transformation?

610

---

What is deployment group?

680

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

774

---

Describe expression transformation?

631

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

1832

---