Answer Posted / suresh

hi rachana

if here there are 100 tables
at that time we have to use 99 joins or is there any
another process for joining the 100 tables from diff
sources into to a single target

let me know if u know the answer

thanks for u r considiration

What is informatica metadata and where is it stored?

978

---

How do you change a non-reusable transformation to reusable transformation?

985

---

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.

2847

---

What is the meaning of up gradation of repository?

1958

---

What is sq transformation?

1139

---

In development project what is the process to follow for an etl developer from day1

1701

---

Explain about Informatica server process that how it works relates to mapping variables?

1047

---

What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

1055

---

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

1019

---

Is there any target staging area in informatica not staging area

2555

---

Explain the types of transformations?

1050

---

Differentiate between router and filter transformation?

1001

---

Why union transformation is an active transformation?

1034

---

What are Dimensional table?

1046

---

what is the size ur source like(file system or database)? how many record daily come u r banking project?

2124

---