what is scd?

6 Answers  

---

Where do you create/define mapping parameter and mapping variable?

1 Answers  

---

I want expect first and last record remaining all records will be loaded into target? which transformations we can use?

6 Answers   Cap Gemini, CTS,

---

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

3 Answers   Cap Gemini,

---

Explain the difference between a data warehouse and a data mart?

0 Answers  

---

---

What is workflow monitor?

0 Answers  

---

I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...

2 Answers   Amex,

---

Enterprise data warehouse your projects phase by phase explain?

0 Answers   Cap Gemini,

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---

Mention few advantages of router transformation over filter transformation.

0 Answers  

---

In informatica workflow manager, how many repositories can be created?

0 Answers  

---

there is a comma separated flat file as source and there is a column in that one field is having space like "rama krishna" like that what happens when this is used as source

2 Answers   TCS,

---