Answer / shiva

limitation is with the sortor cache. the following are its
limitations....
In version 8 it is set to Auto. In version v7 it is 8MB
If it cannot allocate then the session will fail
If it needs more memory that it will pages the data in the
Work Directory, and writes a warning in the log file.

let me know to what extent the answer is correct..

Answer / rayudu

the limitation of sorter t/r is cache
in informatica 8 it is default auto...

can v update d records in target using update stargey without generationg primary key ? explain

4 Answers   CTS,

---

hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  

---

1)can anyone explain how to use Normalizer transformation for the following scenario Source table | Target Table | Std_name ENG MAT ART | Subject Ramesh Himesh Mahesh Ramesh 68 82 78 | ENG 68 73 81 Himesh 73 87 89 | MAT 82 87 79 Mahesh 81 79 64 | ART 78 89 64 | please explain what should be the normalizer column(s) The GCID column 2)Also please explain the Ni-or-1 rule.

5 Answers   FCS, IBM, Satyam, TCS,

---

what is galaxy repository?

2 Answers  

---

Explain load alternative records / rows into multiple targets - informatica

0 Answers   Informatica,

---

can u give example for factless fact table

2 Answers   TCS,

---

Update strategy transformation is an active transformation.How it changes the number of records that pass through it? Please explain....

2 Answers  

---

What is exclusive and normal mode for repository services?

0 Answers  

---

what is the logic will you implement to load data into a fact table from n dimension tables?

4 Answers   TCS,

---

write a query to remove null value follwing table? col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output col1 col2 col3 dinesh suresh prakesh

4 Answers   Accenture, TCS,

---

What is partioning?how many types of partinings are there

2 Answers   HCL,

---

Explian the Process of deployment groups in informatica

0 Answers   Informatica,

---