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.

delete data from staging table as it loads to target table.here is the case we are getting data from 3 different server.a b and c.the data from server A loaded into staging table and we ran the task and data loaded to target table.now today data from server B and C also got loaded to the staging table.now what techniques and what transformations should be used to delete only the data which has been loaded only to the target.we need to delete only that data from staging which has been loaded into the target.looking for your responses

2 Answers   Motorola,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

Create a mapping which contains 2 target tables. When the session runs for the first time it shud load Target table 1 and when it runs for second time it shud load Target table 2.

7 Answers   TCS,

---

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

---

What does “tail –f” command do and what is its use as an Informatica admin.

0 Answers  

---

---

What is confirmed dimension with scenario

1 Answers   HCL,

---

what is left outer join?

3 Answers   L&T,

---

Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

0 Answers  

---

Hi All, i have question regarding Change Data Capture in Informatica. As i know we can do this using Incremental Aggregation(i never worked on Informatica but i read) and i think we can do the same with SQL Over write and with variables. Can someone tell me how do we do this using other two techniques.. using SQL Over write and variables. Thanks for the help and greatly appreciated.

1 Answers  

---

One flatefile it contains some data but i want to dont want to load first and last record ..how it is? can u tell me complete logic?

2 Answers  

---

why we r using presql&postsql in source qualifier?

1 Answers   HP,

---

What is up date strategy and what are the options for update strategy?

2 Answers  

---