Answer Posted / pr
The default join is inner join. But we can override it by using the SQL overide query and can perform any joins
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can we store previous session logs?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
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
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is the function of union transformation?
Describe expression transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
generate date / time dimension in informatica
Explain incremental aggregation in informatica
Can we change Dynamic to Static or Persistent cache? If so what happens?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
How many dimensions are there in informatica?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
How to use procedural logic inside infromatica?
How to implement security measures using repository manager?