Answer / rupali khare

Line item dimension is a dimension,which is deriver from the
fact table and doesn't have it's own dimension table.ie.
degenerated dimension called line item dimension.

can Informatica be used as a cleansing tool? If yes, give examples of transformations that can implement a data cleansing routine.

1 Answers  

---

Knowledge on what are the improtant characteristice that we need ot consider while developing an ETL Code

0 Answers  

---

SCD2 will work on only dimension tables as well as fact Table?

0 Answers   Infosys,

---

Hello all, Source Table(Flat File):- Target Table(Flat File):- Date Date 01/08/2008(DD/MM/YYYY) 01/08/2008 02/08/2008 03/08/2008 04/08/2008 05/05/2008 My requiremnt is this. I need to do it by informatica,Plz tell me how can i do it? Thanks

3 Answers  

---

What is the difference between round-robin partitioning and hash partitioning?

0 Answers  

---

---

what is the difference between shortcut of an object and copy of an object? compare them?

1 Answers  

---

Can we parametrize the values of IN statement. Ex. Inside parameter file: Parameter='A','B','C' Inside Code: IN (INPUT_CHARACTER, $$Parameter)

2 Answers   Cognizant, IBM,

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

0 Answers   SS Solutions,

---

CAN ANY ONE SEND ME THE CODE FOR THE BELOW 1).REMOVE '_' FROM TELE PHONE "323-237-2323" AND SHOULD DISPLAY OUT PUT AS "323237232" 2). NEED TO ONLY "COMPANY.COM" FROM EMAIL FILED "TEST@COMPANY.COM"

11 Answers  

---

you have created a lookup transformation for a certain condition which if true returns multiple rows. when you go to the target and see only one row has come and not all. why is it so and how it can be corrected.

3 Answers  

---

what types of repositories we can create in informatica? in real time in which type of repository we will work on?

2 Answers  

---

IN Informatica, I have 10 records in my source system. I need to load 2 records to target for each run. how to perform.please let me know. I know by using Mapping variable we can perform but how to load please any one explain.

3 Answers   TCS,

---