Answer Posted / hardeep

We can use below configurations to achieve desired output. We need 1 SQ, 1 SGen, 2 Rank and 2 Trgt Defn(same Trt). I think it will be cheaper.

Src-SQualifier-->
|
Rank1(Top 1st) -->Trgt1
--->
Rank2(Bottom 1st) -->Trgt2
|
SGen(NEXTVAL)-->

What are mapplets? How is it different from a Reusable Transformation?

1034

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6045

---

hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

2032

---

r u done any partitions in ur project?

1753

---

What you know about transaction control transformation?

938

---

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

2022

---

How can one identify whether mapping is correct or not without connecting session?

1371

---

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1849

---

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4071

---

How we can create indexes after completing the load process?

1113

---

explain abt ur project architecture?

2124

---

Target increases every day even though no new record was inserted

1516

---

Explain what are the different versions of informatica?

1037

---

explan ur project architecture?

2006

---

Can we override a native sql query within informatica?

989

---