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 the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
What differs when we choose the sorted input for aggregator transformation?
hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is workflow? What are the components of the workflow manager?
Explain the different lookup methods used in informatica?
What is native users?
What is informatica?
How does a rank transform differ from aggregator transform functions max and min?
Explain incremental aggregation in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
explain abt ur project architecture?
What do you mean by enterprise data warehousing?