How to delete the (flat file) data in the target table after
loaded.
Answer Posted / james
whatever data u want to delete from target table,simply go
with truncate option.
| Is This Answer Correct ? | 1 Yes | 14 No |
Post New Answer View All Answers
What is the difference between writing a joiner query in ANSI style and THETA style?
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 are the settings that you use to configure the joiner transformation?
What is an unconnected transformation?
How many number of sessions can one group in batches?
Mention a few design and development best practices for informatica?
During the running session, output files are created by informatica server. Enlist few of them.
How we can create indexes after completing the load process?
What is substr in informatica?
What is a surrogate key?
How we can use union transformation?
Explain the different dimensions.
What is primary and backup node?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What are the basic requirements to join two sources in a source qualifier transformation using default join?