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

Explain about Informatica server process that how it works relates to mapping variables?

841


What is standalone command task?

1034


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1776


How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?

865


Define filter transformation?

882


What are the advantages of using informatica as an etl tool over teradata?

794


What is the Process to creating lookup transformation in informatica

815


Define update strategy?

835


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

6652


Can you generate sequence numbers without using the sequence generator transformation?

854


What happens when a session fails and you click on recover?

879


Describe expression transformation?

886


How can you validate all mappings in the repository simultaneously?

1066


How to configure mapping in informatica?

928


wf dont have integration severances how you can run?

1737