Answer / cbr

In SCD type 2 effective date approach the target table
structure should have kay column, ee_start_date,
eff_end_date and source columns.

1. eff_start_date will be "sysdate"
2. eff_end_date will be "future date"

ex: 01-01-3000(this is what the future date means)

i hope this will help you

Answer / venubyna1

when ll we insert the data into target the systam date
insert into start date and in end date null
tomarrow we insert 50 rec into target table in that 25
update 25 new.
update rec inserting as a new rec(target table contain 50
rec and update as insert means 25 rec inserting from 51)

When do you use sql override in a lookup transformation?

0 Answers  

---

how to use incremental load?

2 Answers   TCS,

---

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers  

---

Different qualification between a related rotate toward the sky and isolates look upward?

0 Answers  

---

What is a connected transformation?

0 Answers   Informatica,

---

What are the different types of olap? Give an example?

0 Answers  

---

how DTM buffer size and buffer block size are related

3 Answers   Wipro,

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

0 Answers   Bosch,

---

what is the main advantage of unconnected lookup

2 Answers   Cap Gemini,

---

1) Alternative to update strategy transformation 2) out of 1000 records after loading 200 records, the session got failed. how do u load the rest of records ?? 3) use of lookup override

3 Answers   IBM,

---

i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,

---

i want to load data in to two targets..one is dimension table and the other is fact table?how can i load ata a time

3 Answers   iGate,

---