Answer Posted / kumarapillaietl@gmail.com

first we integrate data into source to staging tables, from staging we movie into work table at the data moment of stage to work we do all transformation logic , then from work table we load data into fact and dimention table using scd 2.

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6500

---

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1331

---

what is the difference between informatica6.1 and infomatica7.1

2287

---

Explain target update override in informatica

1133

---

Slowly changing dimensions, types and where will you use them

1722

---

What is the maplet?

1131

---

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1973

---

During the running session, output files are created by informatica server. Enlist few of them.

991

---

What is data transformation manager process?

1168

---

write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2556

---

How would you join a node to the already existing domain?

1135

---

What are data-driven sessions?

1223

---

How to update or delete the rows in a target, which do not have key fields?

1186

---

What is workflow manager?

1056

---

What is enterprise data warehousing?

1056

---