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
- 8699 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain why we use partitioning the session in informatica?
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What is meant by query override?
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How do you promote a non-reusable transformation to reusable transformation?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is unit testing?tell me proceedure
What is the benefit of session partitioning?
Explain the pipeline partition with real time example?
What is the different lookup cache(s)?
What is domain and gateway node?
What are ETL Tools?
How do you use reject loader.
How to handle decimal places while importing a flatfile into informatica?
