Answer Posted / bhageerath

src->sq->exp->aggr->tgt

src(col1[int],col2[varchar])

sq(col1[int],col2[varchar])

exp(col1,,col2,v_col1,v_col2,o_col2) {v=variable port, o=output port}

imp:
{ v_col1=col1; v_col2=iif(col1!=v_col1, col2, v_col2||" "||col2); o_col2= v_col2}

aggr(col1,o_col2)

tgt(col1,col2)

What is status code in informatica?

959

---

what is index?how it can work in informatica

1980

---

What is a joiner transformation?

938

---

Differentiate between joiner and lookup transformation?

1048

---

server hot-ws270 is connect to Repository B. What does it mean?

2439

---

What are the different ways to implement parallel processing in informatica?

1340

---

How many numbers of sessions can one group in batches?

1013

---

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.

2797

---

Explain dynamic target flat file name generation in informatica

1008

---

Enlist some properties of sessions.

1020

---

How would you copy the content of one repository to another repository?

949

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

1986

---

What are the prerequisite tasks to achieve the session partition?

1177

---

Tell me about Propagate functions in informatica

874

---

Explain sessions and how many types of sessions are there?

955

---