HOW TO YOU LOAD TIME DIMENSION

1 Answers  

---

Scenario:-  Below is the requirement. Source:-  NAME          ID                    Requirement  RAVI            1                      (no need to repeat as it ID is 1) KUMAR        3                     (repeat 3 times as it ID is 3) John             4                     (repeat 4 times as it ID is 4) Required Out Put:- Name                   ID RAVI                     1                    KUMAR                3      KUMAR                3 KUMAR                3  John                     4 John                     4 John                     4 John                     4 Scenario 2:- Source Data  ID              NAME 1,2            NETEZZA,ORACLE 3,4,5         SQL Server, DB2, Teradata Required Output:-  ID                   NAME 1                  NETEZZA 1                  ORACLE 3                  SQL Server 3                  DB2 3                  Teradata

1 Answers   Cognizant,

---

What is batch and describe about types of batches?

2 Answers  

---

what is the complex transformation you used in informatica

0 Answers   TCS,

---

If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

0 Answers   IBM, TCS,

---

---

scenario where i can use only concurrent execution of workflow.

0 Answers   Cognizant,

---

8.what is mapplet ?give example?

2 Answers  

---

what is update strategy transformation ?

7 Answers   TCS,

---

select * from emp where sal>(select min(sal) from emp) how to implement the same in informatica ?

5 Answers   Puma,

---

what is the gap analysis?

1 Answers  

---

can we use cartesian join in informatica

3 Answers   IBM,

---

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

1 Answers   IBM,

---