Answer / rahul

hi Allen,

i didnt get it.

can you tel what is EOM. y you used month key from monthly
session.

i Question he didnt tell that we are loading on monthly bases.

pls explain it.

Answer / allen

Used a router on only populate target two in the mapping on
EOM. The table was partitioned by day key and month key.
This required only one running of the mapping.

A second method was to use the a lookup override to provide
the month key from the monthly session. This required
running the mapping twice.

how can i invoke pmcmd in command line prompt

1 Answers  

---

split two strings into two columns For Eg. Source:-Full Name: Shiva Kumar Target:- First Name:Shiva Last Name:Kumar

1 Answers   Cap Gemini, TCS, Wipro,

---

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

---

Differences between version 7.x and 8.x.

0 Answers   Accenture, Cognizant,

---

How do you handle two sessions in Informatica

0 Answers   Informatica,

---

---

we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,

---

wf dont have integration severances how you can run?

0 Answers   TCS,

---

what is the hint? how to use it to reduce the query processing in program?

3 Answers   Cegedim,

---

What is the grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.

1 Answers   Zensar,

---

What is informatica? Why do we need it?

0 Answers  

---

What is a taget load order?

2 Answers   IBM,

---

Can we use parameters of parameter file in presession command

1 Answers   Wipro,

---