Answer / shashikiran

If it is horizontal join then we should use joiner transformation having common columns in both the flat files if it is more than 3 flat files, then number of joiners will no. of flat files - 1 i.e,
if suppose there are 4 flat files then 3 joiners are used.
If the flat files structure is same then we can go for vertical joining by using Union transformation or by using indirect file loading concept.

When will you use SQL override in a lookup transformation?

1 Answers  

---

how can u avoid duplicate rows in flat file?

4 Answers   CTS, Wipro,

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

0 Answers  

---

What are the types of caches in lookup?

0 Answers  

---

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

---

Explain the difference between mapping parameter and mapping variable?

0 Answers  

---

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,

---

Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  

---

Differnce between filter and router?

14 Answers   IBM,

---

why we use materialized view over view?

1 Answers   Zensar,

---

how many session run unix environment what command using ?

1 Answers   HCL,

---

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<=5 then what will be the output?

2 Answers   emc2,

---