-
Monthly Goals
If you were falling short on your monthly goals, what would you do differently to see that your goals were met?
-
How do we maintain Primary key in Fact Table ?
Is there any option other than Surrogate key or concatenated key?
-
Extract / Transform Process
Describe the stages of extract / transform process, including what should happen at each stage and in what order?
-
ETL developer Responsibilities
what are the roles and responsibilities of an ETL developer/designer/team lead?
-
Session Execution
What is the first one executed in a session? Is it the Truncate Target Table option or the Post SQL? Explain
-
How three column in one table concatenated in Informatica?
How three column in one table concatenated in Informatica?When i am giving SAL || COMM || DEPTNO in exp it's failed to read during testing.By giving (CONCAT(CONCAT(SAL,COMM),DEPTNO)) i am also getting error during testing.
-
List of all the ETL and Reporting tools available in the market
Can any one let me know where can i find the list of ETL & reporting tolls available in the market. thanks in advance
-
Routing Transformation
Hi, I am new to Informatica just trying to do some mappings. I tried to do SCD type 1. after loading source tables I used expression transformation to do some formatting and then I used Router Transformation. But when I tried to post all fields from expression to router they are by default becoming only input variables . I am unable to link these variables to an Update Strategy. What to do now???...
-
SQL Override and Lookup Override
What is the difference between SQL Override and Lookup Override
-
Join Flatfile Sources
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.
-
Checksum and Pipeline
What do you mean by Checksum and Pipeline in Informatica? Where do you use it ?
-
Use of Aggregator Transformation
In source qualifier transformation we can writer customer query. That means we can do aggregator calculations also. So what is the need of Aggregator Transformation?
-