Answer / shashiall

Run the procedure to load the ttime dimension.Its not
loaded frequently,but once or twice a year.

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

TELL ME ABOUT WORK FLOW SCHEDULING?

3 Answers   TCS,

---

How to join three sources using joiner?

0 Answers  

---

how to call lookup qualifer in unconnected look;up

1 Answers   BirlaSoft,

---

Why touse stored procedure in ETL Application?

2 Answers  

---

Load data to multiple targets according date. When First time session runs it should send to 1st target,second time session runs then send to 2nd target and goes on how to achieve it

1 Answers  

---

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

---

What is target load order?

0 Answers  

---

Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---

Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.

1 Answers   iGate,

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

0 Answers  

---

how do u fnd the duplicate rows and how to delete the duplicate rows?

2 Answers   IBM,

---