How to generate a single mapping for both the historical
and incremental load.
Answer Posted / 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.
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are mapplets? How is it different from a Reusable Transformation?
State the differences between sql override and lookup override?
explan ur project architecture?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
waht type of interface is used for testing the data in informatica
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 ?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the differences between joiner transformation and source qualifier transformation?
can u any challenge your project?
Reusable transformation and shortcut differences
HAI FRIENDS THIS KISHORE FROM KUMBAKONAM. I HAVE COMPLETED MY MCA IN SASTRA UNIVERSITY WAITING FOR MY 6 TH SEM RESULT.DURING MY PROJECT I HAVE DONE INFORMATICA COURSE AS MY AREA INTEREST COURSE IN CORE MIND TECHNOLOGIES CHENNAI.I HAVE ENQUIRY ABT ALL IT PEOPLE FOR DATAWAREHOUSING THERE IS NO OPENING FOR FRESHERS. WITH SOME EXPERIENCE ANY OTHER DOMAIN TNEN ONLY U CAN GET THAT DOMAIN(DATAWAREHOUSING) JOB.BUT I AM MORE INTEREST ON THAT TO WORK ON THAT DOMAIN(INFORMATICA).WHAT TO I DO. I AM IN HELPLESS FRIENDS/EXPORTS.WAITING FOR REPLY
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Why union transformation is an active transformation?
What is depict expression change?