Answer Posted / venkatesh

by using aggrigator transformation we can eliminate
duplicate records in informatica
The flow will be like this

source--->aggrigator----->target

in aggrigator group by all ports then the out put is only
unique records
connect it to the target
2)we can do it by sorter also in sorter if we enable select
distinct then it will gives unique row
3)if u r source is database then u can select distinct in
sourcequalifier it self

what is diff b/t sorter t/r and agg have the option sorter property...

2230

---

While migrating the data from one environment to another environment how would you manage the connections?

1133

---

I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?

1957

---

how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1731

---

How do you promote a non-reusable transformation to reusable transformation?

1179

---

suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

2170

---

Define mapplet?

1059

---

I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .

1989

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2105

---

What can we do to improve the performance of informatica aggregator transformation?

1142

---

What is different between the data warehouse and data mart?

1112

---

How do you set a varible in incremental aggregation

1944

---

source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2780

---

Can we create multiple integration service on single repository?

1240

---

What is expression transformation?

1144

---