Interested to Buy Any Domain ? << Click Here >> for more details...
I've a denormalized table
EMP(empno,ename,phone,addr1,addr2,fax,email). Now I want to
insert the record into target in the format that, there will
be 2 target rows for 1 source record. In target the row
needs to be inserted as:
ROW1: empno,ename,addr1,phone
ROW2: empno,ename,addr2,fax,email
And I'm not allowed to normalize transformation. How to achieve?
- 1 Answers
- 4757 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / rampriya
We can have two target instance of the same table. Load the
first row1 to 1st instance and row2 to 2nd instance.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are the components of Informatica? And what is the purpose of each?
State the differences between sql override and lookup override?
difference between repository database and repository service?
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
Explain in detail about scd type 1 through mapping.
Explian the Process of deployment groups in informatica
explain about unit testing? in real time?
What do you mean incremental aggregation?
explan ur project architecture?
What is meant by a domain?
Enlist few areas or real-time situations where informatica is required.
what is diff b/t sorter t/r and agg have the option sorter property...
What is the function of aggregator transformation?
How do you load unique records into one target table and duplicate records into a different target table?
