Answer Posted / satesh kumar

Hello Mukesh,
Can you plz send me the informatica dump.
My mail id:sateeshdonavalli@gmail.com

Describe expression transformation?

1045

---

What is domain and gateway node?

1122

---

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1951

---

Scheduling properties,whats the default (sequential)

1896

---

What is the need of an ETL tool?

1029

---

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

2435

---

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)

1560

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7318

---

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?

1445

---

What is different between the data warehouse and data mart?

1003

---

What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

1606

---

Define the various join types of joiner transformation?

945

---

What do you understand by a term domain?

1064

---

Parameter and variable differences

2007

---

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

2081

---