write a SQL script like, insert into target_1 (select * from source

Without using any transformations how u can load the data into
target?

Question Posted / dilip

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

Please Help Members By Posting Answers For Below Questions

What are the data movement modes in informatica?

1153

What is meant by query override?

1059

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1581

What are multi-group transformations?

1096

What are some examples of informatica etl programs?

942

Define the various join types of joiner transformation?

988

Mention a few design and development best practices for informatica?

997

What is native users?

1162

Define update strategy?

1226

I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.

2066

What are the reusable transformations?

1166

State the limitations where we cannot use joiner in the mapping pipeline?

1067

Explain what is informatica metadata and where is it stored?

1050

Is it possible to use a client with different version than that of its Informatica server?

1141

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1128