Answer Posted / ramu

Use source Qualifier Transformation,we can edit the default
sql query and write like as
select * from ( select * from emp
order by sal desc)
where rownum <11;

Explain pushdown optimization and types in informatica

1014

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2075

---

What is update strategy transform?

1012

---

How you can differentiate between connected lookup and unconnected lookup?

1003

---

How do you update the records with or without using update strategy?

1051

---

What all join we can perform in LOOKUP transformation?

913

---

can u give example for factless fact table

6440

---

What is InformaticaPowerCenter?

1070

---

While importing the relational source definition from the database, what are the metadata of source that will be imported?

1198

---

Enlist the various types of transformations.

951

---

Explain lookup transformation source types in informatica

1039

---

Write the unconnected lookup syntax?

1029

---

can anyone suggest best free Talend data integration training online

1622

---

Different sorts of metadata that stores in the storage facility?

947

---

What is meant by lookup transformation? Explain the types of lookup transformation?

895

---