Answer Posted / prakash kumar kumhar

ower write sq ("select *from <tableNmae> where rownum <= 10;")
than use two aggregation transformation (in first use first(),and in second use last() for each column)from sq to target.
note: use two target table in which u want to load that two records.

Define filter transformation?

1042

---

Explain the etl program with few examples.

991

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3662

---

How can you validate all mappings in the repository simultaneously?

1311

---

What is persistent lookup cache?

983

---

Is stop and abort are same in informatica?

961

---

Global and Local shortcuts. Advantages.

1983

---

Explain scd type 3 through mapping.

928

---

Do you find any difficulty while working with flat files as source and target?

1063

---

Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance

1939

---

How does a sorter cache works?

1023

---

How many dimensions are there in informatica?

1048

---

Which version configuration tool used in ur project?

3199

---

Write the unconnected lookup syntax and how to return more than one column.

1069

---

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

1074

---