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
- 8918 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 |
What is log file,and where is it located,why u r using the log file
how can we run workflow with pmcmd?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
how to identify new and old values in source qualifier or any other transformations using informatica
If we have 1000 rows were loaded in to datawarehouse and next day the source have 1010 rows so, how can we loaded only updated rows into target.
Design a mapping to get year of join for each employee.
Explain sessions?
Which transformation is needed while using the Cobol sources as source definitions?
suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping using aggregator & router? how
I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.
I want expect first and last record remaining all records will be loaded into target? which transformations we can use?
what is target update override and when we use it?
Teradata 
