Interested to Buy Any Domain ? << Click Here >> for more details...
In my sourse i have like
ename,gender
vasu,male
geetha,female
ram,male
suma.female
kesav,male
in my output i need
male,female
vasu,geetha
ram,suma
kesav
- 5 Answers
- 8645 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / srinivas.medagum
When i used SQ..>EXPRESSION T/R...>ROUTER...>UNION...>TRG
I AM GETTING OUTPUT ,BUT NOT IN PROPER LIKE
MALE,FEMALE
VASU
RAM
KESAV
SEETHA
SUMA
CAN I USE TWO TARGETS , HOW CAN GET IN PROPER WAY?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sakthi
1.sq1 (query override gender='m') -> exp1 ,seq1 gen nextval to exp1
2.sq2 (query override gender='f') -> exp2 ,seq2 gen nextval to exp2
3. connnect o/p exp1 to exp2 to joiner
* condition nextvalue =nextvalue
* condition type full outer join
4. connect name from exp1 & name from exp2 to target
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / shiva bansal
use router and expr1 for male and expr2 for female
combine them in expression transformation and connect the
expression to target
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / suri
Write the condition based on the gender . so that all males
comes one side and females come another side
| Is This Answer Correct ? | 0 Yes | 2 No |
I have 1200 records how can u send it in aggregator with good performance issues?
How to convert IBM Cognos generated XML to a readable XML format for ETL tools
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
can every transfomation reusable?how?
By seeing the parameter file how do u identify wheather it is a workflow parameter or mapping parameter?
Explain lookup transformation is active in informatica
What is difference macros and prompts?
Q. source having mutile depatment of data, dept1, dept2 ....dept10 today. we have mutilple depts in source, we need to generate dept1, dept2 and multile files in target side. today we have 10 dept which have 10 files, tommorow we have only 4 dept and 4 files, dayafter tommorow we have only 6 all the number of files in the targete file directory it's always dynamic. how can acheive it.
what is session parameters?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
Normalizer transformation is not involved in Mapplet.. why???
Teradata 
