Answer / bhanu pratap

Hash partitioning:-
use hash partitioning , when we want the power center server
to distribute rows to the partitions by groups.

Eg :- we need to sort items by item ID , but we don't know
how many many items have a particular ID mamber

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---

Reusable transformation and shortcut differences

0 Answers  

---

How the Informatica Server reads perameter file?

1 Answers  

---

What is use of batch file in informatica? How many types of batch file in informatica?

2 Answers   EXL,

---

What is the Process to creating lookup transformation in informatica

0 Answers   Informatica,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---

Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.

0 Answers   Cap Gemini,

---

How to convert IBM Cognos generated XML to a readable XML format for ETL tools

1 Answers  

---

explain abt ur project architecture?

0 Answers   Anthem, DELL, IBM, TCS, Wipro,

---

What is meant by target load plan?

0 Answers  

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

What are pre and post-session shell commands?

0 Answers  

---