Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kotesh
First it is not text load, it is test load
the power center reads, transforms data and without writing
into targets. the power center generates all session files
and pre-post sql functions, as if running full session. the
power center writes data into relational targets. but
rollbacks data when the session is completes.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Write the advantages of partitioning a session?
What are the settings that you use to configure the joiner transformation?
is it possible to index the data in cache of lkp transformation ?
How do you convert single row from source into three rows into target?
What do you understand by a term domain?
What is InformaticaPowerCenter?
what is the -ve test case in your project.
What is the command used to run a batch?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
what is diff b/t sorter t/r and agg have the option sorter property...
Explain about cumulative Sum or moving sum?
Explain the informatica workflow?
What can we do to improve the performance of informatica aggregator transformation?
What is the way to execute pl/sql script using informatica mapping?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
