Interested to Buy Any Domain ? << Click Here >> for more details...
Source as
1
1
2
2
3
3
How to get target as 1 2 3
and
1
2
3
- 3 Answers
- 9068 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 |
What is intricate mapping?
without matching columns in two tables. how can you join
Can you start a batches with in a batch?
Separate from a database, an information bazaar, and an information stockroom?
what is the main advantage of unconnected lookup
what is confirmed dimension?
write a sql query following source? subject mark maths 30 science 20 social 80 requird output maths science social 30 20 80
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
Explain pmcmd command usage in informatica
Why is sorter an active transformation?
What is meant by lookup transformation?
we have 6 records in source , i need 2nd record in one target and 5th record in one target or 2nd & 5th record in same target.
Teradata 
