Answer Posted / ashok1729

pushdown optimization will improve the performance of the
Load...

Let's see the E.g:

Sq ---> Flter_t ----> Target
[ sal<2000 ]

....

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

6181

---

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

2079

---

What is a transaction control transformation?

1208

---

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1710

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1975

---

What are the types of caches in lookup? Explain them.

971

---

Differentiate between Load Manager and DTM?

2154

---

What are multi-group transformations?

1103

---

Informatica settings are available in which file?

990

---

How to update a particular record in target with out running whole workflow?

1576

---

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

4160

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1856

---

What is dimensional table? Explain the different dimensions.

1172

---

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

2107

---

What is the function of union transformation?

1135

---