suppose i have 1000 records and i want to load half of the
record in target 1 and half in target2.how u'll do?
- 9 Answers
- 11962 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / ramesh
src--->Exp--->Seq--->Rtr---->tgt
in sequence generator we will get a key and in rtr we will
mention condition
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What could be the possible resons of locks by user?
Is it possible to define a single node as a Gateway node as well as worker node?
Please let me know how to make encryption and decryption with example?
How do you load unique records into one target table and duplicate records into a different target table?
What is the difference between a connected look up and unconnected lookup?
How do you load first and last records into target table?
update strategy transformation in informatica
How can you define user defied event?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
How can one identify whether mapping is correct or not without connecting session?
What are the databases that informatica can connect to windows?
how to create user defined function (udf) in informatica
How to create the source and target database connections in server manager?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Hi, In source I have records like this No name address 10 manoj mum 10 manoj dilhi 20 kumar usa 20 kumar Tokyo I want records in target like shown below No name addr1 addr2 10 manoj mum dilhi 20 kumar usa Tokyo If it is reverse we can do this by using Normalizer transformation by setting occurance as 2. Somebody will say use denoralization technique. But as of my knowledge I couldn’t find any denormalization technique. Is there any concept like that? I tryid this seriously but I could find any idea to implement this. Can any one please help me ? Advance Thanks
