What is data merging, data cleansing and sampling?
Answer Posted / sridhar
Data Merging:The process of standing the Structure Of The table(table name,column name,column type.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain joiner transformation in informatica
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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
What is pmcmd command?
How to join three sources using joiner? Explain though mapping flow.
Describe the impact of several join conditions and join order in a joiner transformation?
What is a dimensional model?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What is the Rank index port in Rank transformation?
What are the uses of etl tools?
What are the designer tools for creating transformations?
Explain pmcmd command usage in informatica
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
What do you understand by SOA of Informatica?