Interested to Buy Any Domain ? << Click Here >> for more details...
How to generate a single mapping for both the historical
and incremental load.
- 2 Answers
- 8586 Views
- CSC, TATA, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 1 No |
Differences between version 7.x and 8.x.
0 Answers Accenture, Cognizant,
What is a connected transformation?
what is metadata?
When will u go for Dynamic Cache and Persistent Cache? Pls explain with an example?
3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?
What is the sql query overwrite in source qualifier in informatica
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
how to return multiple columes through through un-connect lookup?
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
What is the use of transformation?
is it reqire primary key and foreign key relation ship to join relational databases?if yes? explain?
My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.
Teradata 
