Answer / niranjana

Datawarehouse objects are Dimension tables,Fact tables,Unique identifiers and relationships

Answer / manju

Sources, Targets, Mappings, Mapplets, sessions, workflows,
worklets, tables, views, sequences,procedures, cursors... are
objects part of data warehouse.

Hi gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance....

1 Answers  

---

SOURECE Name id dept sal 1 a1 A 100 2 b1 B 200 3 c1 C 300 4 d1 D 400 TARGET: Name id dept sal 1 a1 A 100 2 b1 B 200 3 WER1 567 300 4 d1 D 400 I HAVE SOURCE AND TARGET. HOW TO VALIDATE DATA? TELL ME 5 STEPS ABOVE TABLE?

1 Answers   IBM,

---

When do you use mapping parameters? (In which transformations)

1 Answers  

---

why normalizer transformation can not used in mapplet? plzzzz answer

2 Answers   Syntel,

---

What is DR strategy for Informatica project?

0 Answers  

---

---

write sql query following table city gender no chennai male 40 chennai female 35 bangalore male 25 bangalore female 25 mumbai female 15 i want the required output city male female chennai 40 35 bangalore 25 25 mumbai 15

5 Answers   Tech Mahindra,

---

how to delete duplicate records by using filter transfermation?

3 Answers  

---

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

---

I have the source like col1 col2 a l b p a m a n b q x y How to get the target data like below col1 col2 a l,m,n b p,q x y

2 Answers   DELL,

---

We can't use sql override or other properties when using Flat file as source. Then what is the use of Source Qualifier transformation?

3 Answers  

---

Please let me know how to make encryption and decryption with example?

0 Answers  

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---