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
- 8960 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 |
In which circumstances that informatica server creates Reject files?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
how we can load rejected record's at run time?(not through bad files)
in which situations do u go for snowflake schema ?
What is workflow? What are the components of workflow manager?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
tell me 5 session failure in real time how can you solve that in your project?
What are the types of schemas we have in data warehouse.
Explain reference cursor?
Whats the difference between informatica powercenter server, repositoryserver and repository?
on a day i load 10 rows in my target and on nextday i get 10 more rows add to my target but out of 5 are update row how ican send them to target?how i can insert and update the records
I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible
Teradata 
