How You Pull the records on daily basis into your ETL Server.

2 Answers   TCS,

---

Explain target update override in informatica

0 Answers   Informatica,

---

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

---

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 confirmed dimension and fact?

7 Answers  

---

normalizer transformation

3 Answers   CTS,

---

two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .

2 Answers   TCS,

---

What is fact table? Explain the different kinds of facts.

0 Answers  

---

How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,

---

On a day, I load 10 rows in my target and on next day if I get 10 more rows to be added to my target out of which 5 are updated rows how can I send them to target? How can I insert and update the record?

6 Answers  

---

in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,

---

What is status code?

2 Answers  

---