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
- 4837 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
What are the types of caches in lookup? Explain them.
what is mean by flag 4 in update strategy t/r
Router T/R is active but some people are saying it is also passive which is exactly right?
How do you implement scheduling in Informatica?
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain in detail scd type 2 through mapping.
Explain the shared cache and re-cache?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
what is the size of your data warehousing?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is the difference between procedure and stored procedur?
Teradata 
