Answer Posted / guest

Aggregator with group by on column with values 1, 2, 3

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.

2851

---

What are session parameters ? How do you set them?

1841

---

Explain informatica architecture - version 8 / 9

1085

---

Is it possible to define a single node as a Gateway node as well as worker node?

1117

---

what are factless facts? And in which scenario will you use such kinds of fact tables.

1803

---

1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

2128

---

What is incremental aggregation?

1077

---

What are the types of data warehouses?

1514

---

what is the difference between informatica6.1 and infomatica7.1

2267

---

How many transformations can be used in mapplets.

1928

---

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

964

---

What is the commit type if you have a transaction control transformation in the mapping?

1030

---

What is deployment group?

1201

---

Sequence generator, when you move from develoment to production how will you reset

2028

---

tell me 5 session failure in real time how can you solve that in your project?

2285

---