My i/p is 1,2,3,4,5,6,7,8,9,10………..
o/p to be populate in two tables as below.
o/p1: 10,20,30,40,50,60,70,80,90…….
o/p2: 11,21,31,41,51,61,71,881,91…….
Answer Posted / abhinaw prakash
The other approach would be to concatenate the incoming values with '0' and '1' in expression variable port and move it to different targets using Router.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Performance tuning( what you did in performance tuning)
Why sorter is an active transformation?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
How do you convert single row from source into three rows into target?
What does update strategy mean, and what are the different option of it?
What is an expression transformation?
What is option by which we can run all the sessions in a batch simultaneously?
How to do unit testing in informatica? How to load data in informatica ?
draw informatica architecture 8.6 ?
What is the advantage of informatica?
On which transformations you created partitions in your project?
In informatics server which files are created during the session rums?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
Name the different lookup cache(s)?
What you know about transaction control transformation?