Can we update the data in flat file using update strategy?
Answer Posted / pras
Data in flat file cannot be updated
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
Write the unconnected lookup syntax?
What is rank transform?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What is data caches/ index caches?
How we can use union transformation?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the types of caches in lookup? Explain them.
What are the different lookup cache(s)?
What is target load order?
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
What is dimensional table?
r u done any partitions in ur project?
How to start a workflow using pmcmd command?
Which are the different editions of informatica powercenter that are available?
what is the difference between informatica6.1 and infomatica7.1