Interested to Buy Any Domain ? << Click Here >> for more details...
In a scenario I have col1, col2, col3, under that 1,x,y, and
2,a,b and I want in this form col1, col2 and 1,x and 1,y and
2,a and 2,b, what is the procedure?
- 5 Answers
- 10048 Views
- I also Faced
- E-Mail Answers
Answer Posted / k gopi krishna
1. Define source
2. Define SQF
3. put union stage
in first group put col1 and col3
in 2nd group put col2 and col3
4 link it to output file
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
what is INFORMATICA TESTING process
Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks
As union transformation gives UNION ALL output, how you will get the UNION output?
How many ways are there to create ports?
How to use pmcmd utility command?
What is meant by a domain?
Explain what are the different versions of informatica?
What are the transformations that are not supported in mapplet?
To import the flat file definition into the designer where should the flat file be placed?
How an expression transformation differs from aggregator transformation?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Differences between connected and unconnected lookup?
how we can load rejected record's at run time?(not through bad files)
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is powercenter on grid?
