Answer Posted / satya

I dont agree with Ojesh, how do get the value from unix and
store it in variable.

Use a seq.gen t/m and write from SQ and SQE.GEN to Aggr
T/M. find the count and in the router use expressions
1. <= total_count/2
2. > total_count/2


for more details get in touch with me at satya.ylv@gmail.com

-Satya

expain about the tune parameters?

2417

---

What are the reusable transformations?

1166

---

Explain the different dimensions.

971

---

What is workflow? What are the components of the workflow manager?

1146

---

One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

2268

---

What is an unconnected transformation?

1087

---

How do you remove duplicate records in informatica? And how many ways are there to do it?

1168

---

What is a repository? And how to add it in an informatica client?

1150

---

Explain the features of connected and unconnected lookup.

935

---

What are the new features of informatica 9.x in developer level?

1000

---

Name the different lookup cache(s)?

1236

---

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

1955

---

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049

---

What is main use of mapplet?

1133

---

What is powercenter on grid?

1179

---