-
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.
-
Transferring data from text file
How to transfer data from a text file to SQL table, Which is the best method to do that?
-
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???...
-
Join Flatfile Sources
How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.
-
Subqueries vs Joins in SQL
What is the difference between Subqueries and Joins? Which is better and Why? Give an example of each.
-
-