Answer / ankit kansal

Hi,
I have created one example closely have a look. I hope it ll help you.
follow the link

http://deepinopensource.blogspot.in/2013/07/date-dimension-using-informatica.html

Answer / subh

Normally one time loading process is followed for time
dimension. this might be achived by running one time insert
script.

Answer / krishna

in general data is loaded into the time dimension using an
excel file which holds the data starting from a certain
period of time and this is divided into months,days date,
year and all such attributes.

in which situations do u go for sequence generator ?

2 Answers   TCS,

---

when will we use unconnected & connected lookup? How it will effect on the performance of mapping?

5 Answers   Accenture,

---

Explain Dataware house architecture .how data flow from intial to end?

0 Answers   Keane India Ltd,

---

what are the row and column separations in Flat Files

3 Answers   CTS,

---

Differentiate between router and filter transformation?

0 Answers  

---

if the column name in sql override is diff from the column name in source qualifier,what is the impact?

5 Answers   TCS,

---

complex mapping ur project u r invlve can u explain and give real time example give me ?

0 Answers   HGS, TCS,

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.

3 Answers   Amdocs, Deloitte,

---

Why we need XMLs?

3 Answers   IBM,

---

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

---

How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?

7 Answers   iNautix,

---