why we r using presql&postsql in source qualifier?
Answer Posted / 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 |
Post New Answer View All Answers
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How might one distinguish in the case of mapping is right or not without associating session?
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
What is session task and command task?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What are the issues you have faced in your project? How did you overcome those issues?
if we have a delimiters at unwanted places in a flat file how can we over come those.
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is a dimensional model?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
What is meant by a domain?
What is intricate mapping?
Reusable transformation and shortcut differences
Explain lookup transformation is active in informatica
what is index?how it can work in informatica