Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
Answer Posted / anu
take sequence annd router t/r 's
connct nextval port to router
create one group mod(nextval , 2)=0-------target1
default group-----------------------------target2
this is applicable to above six source rows only
this is my second logic
tell me any corrections
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is Index Caches size?
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?
Separate from a database, an information bazaar, and an information stockroom?
can we override a native sql query within informatica? How do we do it?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
Can we create two repositories on same database instance in oracle?
EXL informatica Questions
What differs when we choose the sorted input for aggregator transformation?
What is rank transformation in informatica
What is sq transformation?
What is different between the data warehouse and data mart?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Explain sql transformation in script mode examples in informatica
State the limitations where we cannot use joiner in the mapping pipeline?