Answer Posted / kalyan

Yes, Lookup Condition means is join COndition...By default,
it will give Normal joins..The different types of Join
conditions are =,!=,<,<=,>,>=

Please correct if I am wrong...

complex mapping ur project u r invlve can u explain and give real time example give me ?

2254

---

Can we create a node as a gateway node and the same node can be assigned to a grid?

1048

---

What are the advantages of using informatica as an etl tool over teradata?

993

---

Explain the types of transformations?

1032

---

what is the hint? how to use it to reduce the query processing in program?

7699

---

my source is junk data how will u remove that junk data by using unix please any one replay me

3666

---

Explain informatica architecture - version 8 / 9

1047

---

what is mean by complex business rule ?

2129

---

How does a rank transform differ from aggregator transform functions max and min?

1169

---

What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?

2087

---

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

2829

---

Explain the aggregator transformation?

1111

---

Different sorts of metadata that stores in the storage facility?

974

---

Explain direct and indirect flat file loading (source file type) - informatica

1285

---

What is decode in static cache?

1115

---