Answer / gurpreet singh

Normal Join - All matching rows of A and B
Master Outer join - All rows of detail including matching
rows from master
Detail Outer join - All rows of Master including matching
rows from detail.
Full outer join - All rows from Master and detail table
including matching rows.

How many cubes create from a single model?

1 Answers  

---

Explain sessions and how many types of sessions are there?

0 Answers  

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---

without update strategy how to insert &update?

1 Answers   DELL,

---

What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,

---

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

---

what is the method of error handling when session is running?

1 Answers   TCS,

---

for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.

11 Answers   Accenture,

---

what is the look up transformation?

2 Answers   Informatica,

---

I have 5 sessions s1,s2,s3,s4 & s5 and i want execute s1,s2,s3,s5 after s4. How?

8 Answers   DELL,

---

what is diff b/t sorter t/r and agg have the option sorter property...

0 Answers  

---

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

---