Answer / hari

Connected lookup
1.input ports are connected through pipeline
2.we can have more inputs and more outputs
3connected lookup we can use both static and dynamic cache
4.if condition not match default it give values

Unconnected lookup
1. Inputs are connected through calling :LKP from expression
2.inputs are more and output returns one
3.only static cache can use
4.if condition not match it gives nulls

Describe the impact of several join conditions and join order in a joiner transformation?

0 Answers  

---

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  

---

What is a test load?

1 Answers  

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

---

waht is dataware house

2 Answers  

---

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,

---

Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,

---

How to load last 10 records of flat file in to the target?

5 Answers   iNautix,

---

What is deployment group?

0 Answers  

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

0 Answers   Informatica,

---