Interested to Buy Any Domain ? << Click Here >> for more details...
if i have records like these
(source table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
10001 gfhgdgh
10002 hjkdghkfh
the target table should be like these by using expression
tranformation.
(Target table)
rowid name
10001 gdgfj
10002 dkdfh
10003 fjfgdhgjk
xx001 gfhgdgh
xx002 hjkdghkfh
(that means duplicated records should contain XX in there
rowid)
- 5 Answers
- 12833 Views
- iFlex, I also Faced
- E-Mail Answers
Answer Posted / rao
its not working
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the Rank index port in Rank 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?
Enlist few areas or real-time situations where informatica is required.
Explain the use of aggregator cache file?
What is persistent lookup cache?
What is an expression transformation in informatica?
What are the tasks that source qualifier perform?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is a transaction control transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
where to store informatica rejected data? How to extract the informatica rejected data?
What are the challenges you have faced in your Project (DWH- ETL)? Explain with example?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
write a query to retrieve the latest records from the table sorted by version(scd)
EXL informatica Questions
