Answer / srinu

Look up Transformatoin only,
its going to maintain existing data also in cach memory

Answer / subhransu,bangalore

costly means consuming more memory.which transformation have cache memory.
example:lookup TR
sorter TR
aggregator TR
rank TR
joiner TR

Answer / soujanya

costliest means occupying more memory.
filter
sorter
aggregator
rank
lookup
the transformations having cache memory

What are some examples of informatica etl programs?

0 Answers  

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

---

How do you Merge multiple Flat files for example 100 flat files with out using Union T/F

4 Answers   IBM,

---

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers  

---

What the difference is between a database, a data warehouse and a data mart?

0 Answers  

---

HOE DO U IMPLIMENT SCHEDULING IN INFORMATICA?

7 Answers   Patni, Wipro,

---

HOW TO GET THE LATEST DATA IN SCD ?

4 Answers   TCS,

---

what is the diff b/w target load plan and cbl?

3 Answers   CTS, iGate,

---

Explain in detail scd type 2 through mapping.

0 Answers  

---

what is degenerated dimension

6 Answers   Cap Gemini,

---

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,

---