Answer Posted / chandrasekar

IF WE SELECT THE TARGET LOAD TYPE IS NORMAL, THEN DATA
MOVEMENT IS ROW BY ROW AND STORE AN INSTRUCTIONS IN SESSION
LOG FILE.IF SESSION FAILS, WE CAN RECOVERY THE DATA USING
SESSION RECOVERY AND DATA LOADING IS SLOW. BUT IN BULK TYPE
LOADING DATA IS FAST AND IT DOESN’T MAINTAIN THE SESSION
LOG FILE. IF SESSION FAILS WE CANNOT USE SESSION RECOVERY
IN BULK MODE.

IF I WRONG MEANS PLEASE SEND THE MAIL TO ME
chandranmca2007@gmail.com

can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4714

---

Have you worked with/created Parameter file

1650

---

According to his methodology what all you need before you build a datawarehouse

1741

---

What is primary and backup node?

1116

---

What is joiner transformation in informatica?

1032

---

What is the function of look up transformation?

1109

---

How can we store previous session logs?

1049

---

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?

1493

---

How you know when to use a static cache and dynamic cache in lookup transformation?

1839

---

What is a passive transformation?

1081

---

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

1146

---

Explain target update override in informatica

1099

---

How you can differentiate between connected lookup and unconnected lookup?

1046

---

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

1936

---

Explain the difference between mapping parameter and mapping variable?

1021

---