Which kind of index is preferred in DWH?

2 Answers  

---

What is the internal processes of integration server in Informatica? How data will be extract and load to the target?

0 Answers   TCS,

---

How to load data in informatica ?

0 Answers  

---

whether Sequence generater T/r uses Caches? then what type of Cache it is

7 Answers   Accenture,

---

Explain informatica architecture - version 8 / 9

0 Answers   Informatica,

---

What are the circumstances that infromatica server results an unreciverable session?

1 Answers  

---

Define the various join types of joiner transformation?

0 Answers  

---

What is polling in informatica ?

1 Answers   TCS,

---

Can any body tell about the (UTC) unit test cases with the examples in informatica.

4 Answers  

---

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  

---

my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  

---

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---