Answer / raji

Well,As of my knowledge.....
first u have to take eliminet the duplicates.....like
SRC---->SQ--->AGG---->TGT
in aggr t/f give the group by for both ports...
after this step just use a normalizer t/f to convert these
rows in to columns...

Answer / sushma

SOURCE--->SOURCE QUALIFIER ----> EXPTRANS1 -----> FILTER ---
--> EXPTRANS2 ------> TARGET

In EXPTRANS1, concatenate X1 and X2 values for every 2nd
record (ie X= X2). Lets call this output column as
x1x2_value
Note: I am concatenating for every second record as X1 and
X2 appear alternatively In your sample data,

In the filter transformation, have the filter condition
X='X2' (only these recs have the concatenated data)

In EXPTRANS2, Using substr to split the data into X1 and X2
and load it into target table

Explain your project of banking domian.

0 Answers   Cap Gemini,

---

how we can do session partition in informatica any one explain me clearly? thanks advance.

1 Answers   iGate,

---

How to write a procedure for a date which is in three different formats,and you want to load into datawarehouse in any single date formate

2 Answers   AHM,

---

i hav a scenario like this i want load data from source to target as follows frist it counts the num of deptno and display with that with count and how many times it reapts along with all the records in source

1 Answers  

---

I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?

2 Answers   TCS,

---

Explain the types of transformations?

0 Answers  

---

All active transformations r passive or not?

7 Answers  

---

how you will maintain version?

3 Answers   CTS, TCS,

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

0 Answers   Puma,

---

Clarify the utilization of aggregator cache record?

0 Answers  

---

Can we call a stored procedure from a unix script which is run using command task

1 Answers   TCS,

---