Without using any transformations how u can load the data into
target?
Answer Posted / gaurav rustogi
Simply connected souce with target.
If any condition is there we can put in the Source Qualifier
| Is This Answer Correct ? | 1 Yes | 4 No |
Post New Answer View All Answers
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 does reusable transformation mean?
Enlist few areas or real-time situations where informatica is required.
What is expression transformation?
Did u used latest transformations of 8.6.0? for what?
How to extract the informatica rejected data?
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 the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
What are the popular informatica products?
Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.
What is native users?
Can we override a native sql query within informatica?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Do you find any difficulty while working with flat files as source and target?
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