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

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

0 Answers   Cap Gemini, Cognizant,

---

If session fails after loading 10000 records in the target,how can we load 10001 th record when we run the session in the nexttime?

8 Answers   HeadStrong, TCS,

---

Scenario is like this: Name Sal A 10; B 20; C 30; Then Output should be Name Sal A 10; B 20; C 30; Total 60; Use SQL For this scenario

4 Answers   TCS, Wipro,

---

A mapping contains (1) Source Table S_Time ( Start_Year, End_Year ) (2) Target Table Tim_Dim ( Date, Day, Month, Year, Quarter )

1 Answers  

---

What do you mean incremental aggregation?

0 Answers  

---

What is critical mapping?

2 Answers  

---

How does the server recognize the source and target databases. Elaborate on this.

1 Answers  

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---

What are the join types in joiner transformation?

1 Answers   Informatica,

---

what is inline view?

1 Answers   IBM,

---

What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

0 Answers   IBM,

---

How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,

---