Answer Posted / abhinaw prakash

there must be a problem while importing the flat file.A column must be in different data type as compared to the defined data type while importing.
Please provide the log for better analysis.

Name the different lookup cache(s)?

1235

---

Scheduling properties,whats the default (sequential)

1955

---

What is the difference between router and filter?

1269

---

what is unit testing?tell me proceedure

2223

---

What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1155

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1512

---

Explain what are the different types of transformation available in informatica.

1150

---

What are the performance considerations when working with aggregator transformation?

1152

---

Is it possible to revert a global repository to local one and why?

1081

---

How do you load only null records into target?

1216

---

How many number of sessions can one group in batches?

1157

---

What is decode in informatica?

1165

---

Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7391

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6181

---

Explain joiner transformation in informatica

1124

---