Answer / seshagiri k

1.Both the pipelines begin with the same original data spouece
2.Both input pipelines originate from the SQ transformation
3.Both input pipelines originate from the same normalizer t/r
4.Either input pipelines contains an update transformation
5.Either input pipelines contains a connected or unconnected
sequence generator transformation

Answer / maruthi

JOINER,AS IT JOINS DATA FROM HETROGENOUS SOURCES
1)STRUCTURE OF THE BOTH TABLES SHOULD BE SAME.(V.IMP)
ANYWHERE SAY IT FIRST

Enlist few areas or real-time situations where informatica is required.

1 Answers  

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1 Answers   IBM,

---

What are the mapping parameters and mapping variables?

1 Answers   Informatica,

---

How does the aggregator transformation handle null values?

1 Answers  

---

What is a data modeling?

2 Answers  

---

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers   Accenture,

---

In Flat file Input is A B C I need output like this A A A B B B C C C. How will u achieve this?

5 Answers   iNautix,

---

What is fact table? Explain the different kinds of facts.

1 Answers  

---

What is update override?

1 Answers   Accenture,

---

Describe expression transformation?

1 Answers  

---

There are 4 flat files with number of records as indicated below. Which files should be picked first for joining using joiners so as to get best performance. File A - 1000 records File B - 100 records File c - 10000 records File D - 10 records Please explain. Thanks and Regards,

1 Answers   Amdocs,

---

what is row level and column level indicator?

1 Answers   TCS,

---