Answer / sunil

)At DB level we can simply DROP the stagin table.
2)then Create Target table at DB level.
3) Directly LOAD the records into target table.

NOTE: It is recommended to use staging area

How do you implement unconn. Stored proc. In a mapping?

1 Answers  

---

what is mean by grouping of condition column in lookup transformation?

1 Answers  

---

Three date formats are there . How to change these three into One format without using expression transformation ?

3 Answers   HP,

---

What are events in workflow manager?

1 Answers   Accenture, IBM,

---

What is the Difference between sorter and aggregator?

2 Answers  

---

Can we run session without using workflows?

5 Answers   TCS,

---

in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

0 Answers  

---

i want excute multiple sessions in one workflow using the "start task".what do i need to do?

2 Answers  

---

can we have to do changes in session property when we are dynamically generating target files?

3 Answers   Wipro,

---

Hi ETL gurus can any one tell me with a flow how to implement SCD Type 1 and SCD Type 2 in a single mapping.For some fields SCD type has to be implemented and for some fields scd type has to be implementd..Thank in advance..please let me know in case of any concerns...

1 Answers  

---

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

---

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers  

---