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
- 9064 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 |
whatis the default data driven operation in informatica
1,If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?
4 Answers CompuSoft, EDS, TCS,
There are n numbers of flatfile of exactly same format are placed in a folder .Can we load these flatfile's data one by one to a single relational table by a single session??
What is a taget load order?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
write a sql query following table? col1 col2 1 2 1 2 1 2 3 4 3 4 5 6 i want the output like unique duplicate col1 col2 col1 col2 1 2 1 2 3 4 1 2 5 6
COM components can be used in Informatica
write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000 can anybady help me to achieve the aboue result by using informatica. thanks in advance.
What is rank transform?
Explain direct and indirect flat file loading (source file type) - informatica
What is informatica powercenter repository?
If you have 10 mappings designed and you need to implement some chages (may be in existing mapping or new mapping need to be designed) then how much time it takes from easier to complex?
Teradata 
