1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / paramaguru

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


Please Help Members By Posting Answers For Below Questions

What are the data movement modes in informatica?

695

Explain sql transformation in script mode examples in informatica

597

What is a node in Informatica?

617

Explain the different lookup methods used in informatica?

581

What are the designer tools for creating transformations?

675




How big was your fact table

1309

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

1469

What are the differences between source qualifier and joiner transformation?

589

what is degenerated dimension?

3144

What is rank transformation?

570

Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?

1497

Differentiate between joiner and lookup transformation?

608

Enlist few areas or real-time situations where informatica is required.

585

Define mapplet?

622

Why sorter is an active transformation?

744