Answer Posted / nagendrareddy
unique is constraint which will not allow duplicate records
into batabase..
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
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
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
What is meant by incremental aggregation?
What are different types of transformations available in informatica?
can u any challenge your project?
What is deployment group?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
What is meant by pre and post session shell command?
can you please explain me pre session and post session options?
How many number of sessions can one group in batches?
What is an expression transformation?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What is lookup change?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
How can you generate reports in informatica?