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
- 4731 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
How can we use mapping variables in informatica?
What does role playing dimension mean?
What is the function of aggregator transformation?
what is the hint? how to use it to reduce the query processing in program?
How can repository reports be accessed without sql or other transformations?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
how to load dimension table and fact table. plz tell me the steps.
what is song in infrmatica...?
What is aggregate cache in aggregator transformation?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Differentiate between sessions and batches?
How to handle decimal places while importing a flatfile into informatica?
Differences between version 7.x and 8.x.
Enlist few areas or real-time situations where informatica is required.
