i have a source table
ID NAME SAL
101 A 1000
102 B 2000
103 C 1500
target load should be
ID NAME SAL
101 A 1000
101 B 2000
101 C 1500
102 A 1000
102 B 2000
102 C 1500
103 A 1000
103 B 2000
103 C 1500
Answer Posted / kondeti srinivas
IF IT IS SOURCE FLAT FILE THEN SQL OVER RIDE WILL NOT WORK
IF IT IS FLAT FILE USE UNION TRANSFORMER AND
CONNECT 3 SAME SOURCE STRUCTURES OF FLAT FILES TO UNION T/F AND CONNECT TO TARGET. IT WILL GIVE THE REQUIRED OUTPUT
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
Explain the different lookup methods used in informatica?
What are the components of Informatica? And what is the purpose of each?
What is aggregator transformation in informatica?
Differentiate between joiner and lookup transformation?
Differentiate between a repository server and a powerhouse?
What is a predefined event?
Explain your project of banking domian.
On which transformations you created partitions in your project?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks
Reusable transformation and shortcut differences
What is an active transformation?
Differentiate between reusable transformation and mapplet.
Explain sessions. Explain how batches are used to combine executions?