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
- 4771 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 happens if you try to create a shortcut to a non- shared folder?
How do you load first and last records into target table?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
What are mapping parametres and variables in informatica?
What are the main issues while working with flat files as source and as targets ?
Define the various join types of joiner transformation?
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?
6 Answers iFlex, Morgan Stanley,
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
Teradata 
