what is sql override?what is the use of it?
Answer Posted / sunil
When u want to override the default sql query we will use
sql override
Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
my source is junk data how will u remove that junk data by using unix please any one replay me
How can you differentiate between powercenter and power map?
r u done any partitions in ur project?
what are factless facts? And in which scenario will you use such kinds of fact tables.
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
how to load dimension table and fact table. plz tell me the steps.
Explain the code page compatibility?
Mention some types of transformation?
What all are steps in up gradation of Informatica server?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What is the benefit of partitioning a session?
What is the session task and command task?
How can we store previous session logs?
What are the different transaction levels available in transaction control transformation?
can we override a native sql query within informatica? Where do we do it?