Answer Posted / ramarao

Hi Friends,

I think this possible by using source Qualifier ALSO.

The Senario is

Issue_id,Question,Answer
100,1,y
100,2,n
100,3,y
100,4,n

Target is issue_id,Answer1,Answer2,Answer3,Answer4
100, y,n,y,n

This can be Achived by using source Qualifier And joiners.
There is no need to use Normaliser.

What are the ETL Testing Operations?

987

---

HI, Anybody is having informatica Dumps,if it there Can u send to my mail id :sathesh.cool@gmail.com

1991

---

What is a staging area? What is the purpose of a staging area?

824

---

what is the use of server manager?

2054

---

What are the different etl testing categories as per their function?

1002

---

Difference between flat files and relational sources?

2219

---

how many steps are there in etl process?

918

---

How to fine tune mappings?

875

---

what are the reports created in mm and sd side using sap bw in a project? name some of them and explain the requirement?

2058

---

can u anyone plz share some etl testing interview question . and share the sql queries and unix . plz help me to clear in the etl testing interview by sharing ur knowledge

1743

---

how do u handle performance issues in Informatica . where can u monitor the performance ?

4687

---

Hi, I've a mapping with flat file source The target update override property for the target table is using update stmt. There is no update strategy between source and target. Also The session has the target properties as Insert , Update as update options checked. Does this mean that recs will be inserted only and the update override will not be applied at all. Thanks

1715

---

how do u really know that paging to disk is happening while u are using a lookup transform?

1928

---

What is etl process. How many steps etl contains explain with example?

892

---

hoe to access second value in mapping parameter if it is having more than one value ?????????????

1479

---