How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
What is flashback table ? Advance thanks
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
can we send mail when ever it get success or faulure to other mailid?(Not company mail id)
In pmcmd command we need to type -p:password. Will it be visible to others who is having access to this file ?
As a support project team member, how will you get the questions regarding errors from client or customers (in which format)?1 2875
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?2 7727
What is informatica worklet?
Which version configuration tool used in ur project?
Enlist few areas or real-time situations where informatica is required.
How do we call shell scripts from informatica?
Difference between Target-based loading and constraint-based loading?
What do mean by local and global repository?
Target increases every day even though no new record was inserted
pmscmd startworkflow -sv
What is a snowflake schema?
What is joiner transformation in informatica?
can we override a native sql query within informatica? How do we do it?
How to start a workflow using pmcmd command?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
What do you mean by channel change?