Answer Posted / rag

Hi You can do this another way also
put the expresession transforamtion and read some previous
record with the currect record or any unique column value in
the expression and if they are equal then assign the
flag(means duplicate flag) else
assign the new flage.
pass the duplicate flag records to the filter and goes to
the TB(duplicate records target) and unique values to the
origonal target

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

2144

---

How can we handle two sessions in informatica?

1029

---

Explain informatica architecture - version 8 / 9

1086

---

How to convert multiple rows to single row (multiple columns) in informatica

1376

---

What is substr in informatica?

1203

---

How to elaborate tracing level?

1171

---

What is mapplet in informatica?

1053

---

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

2558

---

Clarify the utilization of aggregator cache record?

994

---

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.

2856

---

Explain the etl program with few examples.

1046

---

What is source qualifier transformation in informatica?

1003

---

Which transformation should we use to normalise the COBOL and relational sources?

1200

---

What is dimensional table?

1060

---

What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1198

---