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
Explain the informatica workflow?
How can one identify whether mapping is correct or not without connecting session?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
lookup transformation with screenshots
explan ur project architecture?
Explain the use of aggregator cache file?
explain about unit testing? in real time?
What are roles and groups and benefits of using them?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is data movement mode in Informatica and difference between them?
Different circumstance which drives informatica server to expel records?
What is transformation?
whats the logic to load the lower level of granularity of data to fact table.
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are different types of transformations available in informatica?