why we r using presql&postsql in source qualifier?
Answer / amedela chandra sekhar
Presql :sql statement executed before the session retrive
the data from source.
Postsql:sql statement executed atfer the session retrive the
data from source.
Is This Answer Correct ? | 10 Yes | 0 No |
can we have to do changes in session property when we are dynamically generating target files?
How can you complete unrcoverable sessions?
can we override a native sql query within informatica? Where do we do it?
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What is the reusable transformation?
Sequence generator, when you move from develoment to production how will you reset
Explain the different kinds of facts.
Could you explain what is enterprise data warehouse?
I have source like col1,col2,col3,col4 and the values are like 3,6,1,7 1,5,3,8 2,1,5,6 i want the output like 3,6,7 5,3,8 2,5,6 How we will achieve in this scenario in informatica level. Please help me.. Thanks in advance..
What is Collect performance data in informatica and what is the use of it.
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?