Answer Posted / krishnakanth.ch
There are many ways....
1) Using the sql override in the source qualifier. To find
the even and odd. Add another column to flag the even and
odd.Like
select ID,decode( id/2,0,'E','O') FLAG FROM TABLE_NAME;
Using the router we can send them into two seperate target
tables.
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
wat are deployement groups in informatica, how it will be used for developers
What is blocking transformation?
State the differences between sql override and lookup override?
What do you mean by filter transformation?
Can we create two repositories on same database instance in oracle?
How to elaborate powercenter integration service?
Performance tuning in UNIX for informatica mappings?
Describe the impact of several join conditions and join order in a joiner transformation?
What are pre and post-session shell commands?
What is meant by LDAP users?
What is intricate mapping?
What is the different lookup cache(s)?
What are the types of lookup transformation?
Explain the different dimensions.
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com