Hi,
I have one scenario.. i want to insert 4 times (Duplicate)
a row in the target. Please help me .
source row: abcabc
Tgt table:
abcabc
abcabc
abcabc
abcabc
Answer Posted / paramaguru
source qualifier---field1
connect field1 to all the 4 field in the normalizer.
normalizer: In the normalizer maker occurs as 4
it will creat automatically
NEWfield1
NEWfield2
NEWfield3
NEWfield4
NEWFIELD
GK_NEWFIELD
GCID_NEWFIELD
target:OUTPUT
connect newfield to the target output
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the use of target designer?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Explain the etl program with few examples.
whats the logic to load the lower level of granularity of data to fact table.
Differentiate between sessions and batches?
What is the difference between informatica 7.0 and 8.0?
how to load dimension table and fact table. plz tell me the steps.
What are Dimensional table?
Explain sessions?
Enlist the advantages of informatica.
Where is metadata stored?
What are the components of workflow manager?