Answer / sehaj

IN A QUERY WE CAN USE ALL THE THREE....BUT USING WHERE N
HAVIN DOESN MEAN ANY SENSE...
IF WE USE GROUP BY WE CAN USE WHERE CLAUSE BEFORE GROUP BY
PORT...
AND IF WE USE GROUP BY WE CAN USE HAVING AFTER GROUP BY CLAUSE..
N GENERALLY ORDER BY CLAUSE IS ALWAYS WRITTEN AT THE END OF
THE QUERY

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

---

Performance tuning( what you did in performance tuning)

0 Answers   Infosys,

---

explain different levels in pushdown optimization with example?

2 Answers   TCS,

---

How to load time dimension?

1 Answers   Ford,

---

what are the transformations that restricts the partitioning of sessions?

1 Answers  

---

How to compare Source and Target table, without using dynamic lookup?

4 Answers  

---

In router source is a boy age 20 I given 3 conditions in router a>20, a<=20, a=20 which one exit first?

3 Answers  

---

what are the differences between powercenter 8.1 and powercenter 8.5?

2 Answers  

---

What is the target load order?

3 Answers   HCL, Informatica,

---

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,

---

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  

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---