Without using any transformations how u can load the data into
target?
Answer Posted / dilip
write a SQL script like, insert into target_1 (select * from
source_1) and run it in the pre/post source/target load.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
what is diff b/t sorter t/r and agg have the option sorter property...
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
When do you use sql override in a lookup transformation?
How do you change a non-reusable transformation to reusable transformation?
explan ur project architecture?
what is $$$$?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
Explain joiner transformation in informatica
What is a pre-defined event and user-defined event?
Explain in detail scd type 2 through mapping.
Explian the Process of deployment groups in informatica
What is a surrogate key?
What are the uses of etl tools?
What are mapplets? How is it different from a Reusable Transformation?