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.

The structure of source file is as below: Source structure(two fields) Name, Card NUmber A, 111111111(SSN) A, 01010101(Creditcard number) A, 34343434(Debit card number) B, 55555555(Creditcard number) C, 77777777(Debit card number) Target Structure(4 fields) Name,Credit card,SSN,Debit card A,01010101,111111111, 34343434 B,55555555,, C,,,77777777 Corresponding to one name there can be maximum 3 rows and minimum zero rows. Given that I do not know which record might have a particular type of number. How can I handle above requirement with informatica transformations?

1 Answers   Amdocs,

---

how can run the wf through pmcmd commend? write script?

2 Answers   Cap Gemini,

---

How to load duplicate records in to a target table which has a primary key?

2 Answers  

---

how can we load starting with 11th record of a table from source to target

6 Answers   IBM,

---

What are different types of transformations available in informatica?

0 Answers  

---

what is upstream and downstream transformation?

7 Answers  

---

If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?

2 Answers  

---

on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records

4 Answers   Fidelity,

---

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

0 Answers  

---

performance tuning of Informatica

1 Answers  

---

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

---

we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.

8 Answers  

---