Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000.
but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
No Answer is Posted For this Question
Be the First to Post Answer
what is the process we used in joiner transformation,there is no matching column in sources?
how we can update a target table without update strategy and update override?
how can one eliminate dupliacte data with out using distinct option?
What are the reusable transforamtions?
what is degenerated dimension?
we have table like cust_id,cust_name,cust_loc like this 1.we need to get perticular location,to do this we can use filter transformatin,that logic is same for relation table and flat file tabl?
Using Expression transformation how to remove duplicate records from a relational source?
What exactly mentioned in High level design document.can somebody explain me sequentialy.
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.
Define pmcmd command?
Please let me know how to make Data masking in informatica..
How identifying bottlenecks in various components of informatica and resolving them?