Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
- 3 Answers
- 8175 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / anu
Select distinct in sorter t/r
then run session twice
but don't enable truncate option in session target properties
I think so
any corrections tell me
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / arjun
hi,
take aggrtr in that take one var , count the var group by i/p these go to one tgt and take another same tgt for that, take aggrtr ports i.e, i/p and var ports to filter in that give cndtion not isnull(var) and take i/p port to secnd tgt.
| Is This Answer Correct ? | 0 Yes | 0 No |
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
What is a repository? And how to add it in an informatica client?
Is scd logic we have lookup right to compare the values with source and target,instead of lookup can u have any transformation or any way to do this?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Can any body tell about the (UTC) unit test cases with the examples in informatica.
When the informatica server marks that a batch is failed?
What is the difference between SOURCE and TARGET BASED COMMITS?
Where are the source flat files kept before running the session?
which one is costliest transformation? costliest means occupying more memory. which one Aggregator,sorter,filter,etc..
What is joiner cache?
What is the need of etl tools?
what are the enhancements made to Informatica 7.1.1 version when compared to 6.2.2 version?
Teradata 
