source table have single column single record having with
single space.
load that source record into trg . trgt having two columns
and the
SOURCE TABLE LIKE

COL1
BHANU PRASAD
TRGT TABLE
COL1 COL2
IN THAT LOAD THE RECORD IN THE trgt table LIKE
COL1 COL2
BHANU PRASAD
HOW ? TELL ME PLZ

Answer Posted / raj

Nice answer keeep it up

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

619


What does role playing dimension mean?

630


How to generate sequence numbers?

619


Can we create multiple integration service on single repository?

705


How to update or delete the rows in a target, which do not have key fields?

653






What is data transformation manager process?

622


How can we update a record in the target table without using update strategy?

658


How can you differentiate between powercenter and power map?

626


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

611


Why update strategy and union transformations are active?

594


What is the scenario which compels informatica server to reject files?

608


Make a note of the quantity vaults made in informatica?

561


Mention few power centre client applications with their basic purpose?

538


suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do

1735


How to do unit testing in informatica? How to load data in informatica ?

654