Answer Posted / swetha

When a Joiner transformation occurs in a session, the
Informatica Server reads all the records from the master
source and builds index and data caches based on the master
rows.After building the caches, the Joiner transformation
reads records from the detail source and perform joins.

Partition, what happens if the specified key range is shorter and longer

2509

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1633

---

what is INFORMATICA TESTING process

2307

---

how to create user defined function (udf) in informatica

1315

---

What is the use of an aggregator cache file?

1209

---

How to extract sap data using informatica? What is abap? What are idocs?

1194

---

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

1067

---

tell me about your project functionality

2350

---

What is session task and command task?

1310

---

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?

1520

---

What are the measure objects?

1215

---

Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

1059

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1938

---

what are 3 tech challenges/ common issues you face?

2351

---

hi real timers . iam waiting for ur reply regarding ETL TESTING

2282

---