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


Please Help Members By Posting Answers For Below Questions

What is domain in terms of informatica?

773


In which transformation you cannot drag ports into it?

1047


How many transformations can be used in mapplets.

1672


Whats the difference between informatica powercenter server, repositoryserver and repository?

930


What is an expression transformation?

810


What is a predefined event?

855


What is a node in Informatica?

820


What is workflow monitor?

796


What does reusable transformation mean?

869


What is decode in informatica?

827


tell me the rules and responsblites in our project(my project is development)

1708


Explain constraint based loading in informatica

838


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6408


Partition, what happens if the specified key range is shorter and longer

2221


Define update strategy?

824